Hi all,
I am currently using the formula =INDIRECT($C$2&"!A1") which works fine.
what I now need is for the box below to be =INDIRECT($C$2&"!A2") and so on, down until A330
is this possible without manually changing the A1 to A2, A3, A4 and so on?
Thanks
Rick