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
|