Hi rajkohli

Thanks for the reply.
Sorry it did'nt, because I failed to mention that the activecell is is an
entirerow, so when it pastes to the new sheet it removes the formula. Is
there a way to turn a 1 into a 2 after it has been copied to the newsheet.

"rajkohli" wrote:

=sheet1!(a1).

I think you are asking for this formula. It will change the value of current
cell (doesn't matter on which sheet you are currently working) to value of
Sheet 1's A1 cell. Means if Sheet 1 A1 = 100 and you are currently working on
Sheet 2 F1, then this formula will show the F1 value to 100 and if you will
change the value of A1 from Sheet 1 then it will automatically changed on
Sheet 2 as well.

Hope this will help, let us know!
"A.R.J Allan Jefferys" wrote:

,Hello Again

Could i get some help with this.
How does one get an activecell , that has a value of 1, that is copied from
sheet1 to sheet2 so that the value changes from 1 to a 2 and so on depending
on how many times I copy a sheet.

I hope this makes sense

Thanks in Advance
Allan