Hi,

I am trying to have progressive numer in differnt sheets of the same
cell by copying. Can anybody give me a clue? Thanks.

For example, there are three working sheets as below

A1=400 A1=401 A1=402
sheet 1 sheet 2 sheet 3

the A1 of 'sheet 2'! should be 'sheet 1'!A1 +1
and A1 of 'sheet 3'! should be 'sheet 2'!A1 +1

What the formula could be to achieve the above? Thanks.

Lee