Forum Discussion

Bob_Sutton's avatar
Bob_Sutton
Copper Contributor
Oct 11, 2024
Solved

Access different worksheets based on contents of a cell

I would like to access data from different worksheets based on the contents of a cell in the current worksheet without re-doing all the formulae.  Basically, I have a template worksheet and want to p...
  • HansVogelaar's avatar
    Oct 11, 2024

    Bob_Sutton

    Are your sheets literally named Sheet1, Sheet2, etc.?

    If so: enter a number such as 2 in a cell, say A1.

    In another cell, enter the formula

    =INDIRECT("Sheet"&$A$1&"!D3")

    to return the value of D3 on the indicated sheet, or

    =INDIRECT("Sheet"&$A$1&"!D3:F20")

    to return a multi-cell range.

Resources