Variable sheet in excel formulas, calling dynamic sheet name
Sometimes we need to use in our excel formulas a certain sheet depending on different conditions.
Calling variable sheet name in excel formulas
For example, if we want to create an easy to use report which needs to apply consolidating formulas on data available on a certain sheet, depending on the user choice. Let’s say that the user wants to list a sales report for July, where Jul2018 is a worksheet name in our excel file. The user will input in cell A4 Jul2018 and in cell C4 there are is a formula which summarizes the sales from the month selected.
You can download the formula excel file for more practical experience.