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

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