Hi Shane,

I have been following this post and it works fine as explained.

However, I would appreciate your explanation of the formula (the 2nd one)

Kind regards

Preman

"ShaneDevenshire" wrote:

Hi,

Try this

=INDIRECT("Sheet"&ROW()&"!A"&COLUMN())

Assuming you are in cell A1 for the first formula. if not

=INDIRECT("Sheet"&ROW(A1)&"!A"&COLUMN(A1))

copy down and to the right

If this helps, please click Yes
--
Thanks,
Shane Devenshire


"iain_greenan" wrote:

I need to increment the sheet number as i move down a table

ie.

sheet1A1 sheet1A2
sheet2A1 sheet2A2
sheet3A1 sheet3A2
sheet4A1 sheet4A2