incrementing sheet number

  • Thread starter Thread starter iain_greenan
  • Start date Start date
I

iain_greenan

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

ie.

sheet1A1 sheet1A2
sheet2A1 sheet2A2
sheet3A1 sheet3A2
sheet4A1 sheet4A2
 
Thank you for responding, i guess i made a newbie mistake and didn't explain
well enough.

i need the data from cell a1 in sheet1 to be displayed elsewhere and the
data from cell a1 in sheet2 below it.

thanks again.
 
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
 
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
 
Back
Top