Ad Clicks :Ad Views :
    Excel formulas and tutorials

    Excel formulas and useful tools

    img

    Variable sheet in excel formulas, calling dynamic sheet name

    /
    /
    /
    309 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