Content cell to determine which sheet to look at
Hi Martin,
Thanks for the quick response and thank you for providing me with a solution
to my problem. It worked like a charm. I really appreciate it.
Thank you.
Mark
"MartinW" wrote:
Hi Mark,
With 37 in C1 38 in D1 etc.
=INDIRECT("W"&C1&"!A1") in C2 and dragged across
will return A1 from sheet W37, W38 etc.
Is that the sort of thing you are looking for?
HTH
Martin
|