Here is a great and effective approach to shuffle columns of data. It will use the Excel HLOOKUP function, and not require any VBA macros or complicated re-engineering of this summary worksheet.
This is an introductory examination into the use of Excel Custom Format Cells, in order to improve the cosmetic appeal of a best practice financial model.
There are many ways to verify or analyse financial outputs. Clearly all financial outputs must be correct, but the financial analyst must be able to deliver added value via summaries, dashboard and Excel charts. This article and video will focus primarily on Excel Traffic Lights, via Excel Conditional Formatting, in order to improve the analytical demonstration of high-level financial performance
Here is a simple macro-free alternative to Excel Data Sort, which will seamlessly sort data in a financial model or spreadsheet.