Ad Clicks : Ad Views :
Excel formulas and tutorials

Excel formulas and useful tools

img

Variable sheet in excel formulas, calling dynamic sheet name

/
/
/
35 Views

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.

 

  • Facebook
  • Twitter
  • Google+
  • Linkedin
  • Pinterest

Leave a Comment

Your email address will not be published. Required fields are marked *

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

This div height required for enabling the sticky sidebar