="Sheet" & ROW() & "A1" and copy down
--
Gary''s Student - gsnu200812


"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