Forum Discussion
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...
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.
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.
Thanks Hans, it worked. I played around with the INDIRECT function but missed the part where the cell number is concatenated to the end of the argument string as text.