View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bony_tony bony_tony is offline
external usenet poster
 
Posts: 76
Default 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