ExcelBanter - Refer to a sheet using a cell value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Refer to a sheet using a cell value (https://www.excelbanter.com/excel-worksheet-functions/194538-refer-sheet-using-cell-value.html)

bony_tony

Refer to a sheet using a cell value

Hi, on "Sheet1" in cell A1 I have the string "Tony". I also have a
sheet named "Tony"
I want to display the value of cell A1 in the sheet "Tony" on
"Sheet1".
Instead of using =Tony!A1 I would like to somehow use the the value in
A1 ("Tony") to refer to the cell. I can then copy the formula to other
cells easily to reference other sheets..
Thanks

Mike H

Refer to a sheet using a cell value

Try this

=INDIRECT("'"&A1&"'!A1")

Mike

"bony_tony" wrote:

Hi, on "Sheet1" in cell A1 I have the string "Tony". I also have a
sheet named "Tony"
I want to display the value of cell A1 in the sheet "Tony" on
"Sheet1".
Instead of using =Tony!A1 I would like to somehow use the the value in
A1 ("Tony") to refer to the cell. I can then copy the formula to other
cells easily to reference other sheets..
Thanks

bony_tony

Refer to a sheet using a cell value

Thanks for filling another hole in my Excel knowledge! ;-)

All times are GMT +1. The time now is 05:43 AM.