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.

=SUM(INDIRECT(“‘”&A4&”‘!C:C”))

You can download the formula excel file for more practical experience.

 

 

Write a Reply or Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.