Thread: Have a worksheet = cell value (Time!B2 vs C2!B2 when C2 = Time)?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default Have a worksheet = cell value (Time!B2 vs C2!B2 when C2 = Time)?
Try:

=INDIRECT("'"&$A$1&"'!B2") where A1 contains sheet name

"turn?around" wrote:

How can I set the worksheet I am referencing in a formula to be the text in a
cell? I have many worksheets with the same formatted data. If I am able to do
this I can pull the data I need from each worksheet without retyping my
formulas by just referencing a row of worksheet names.
Microsoft Excel 2003 Professional
Reply With QuoteReply With Quote