123rickfear
Active Member
- Joined
- Jun 19, 2015
- Messages
- 446
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
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