Hello,

I am currently creating a template for some shipping documents and these
documents usually have about 30-40 identically formatted worksheets. Several
cells within the worksheets have to be entered manually, of course, but I
would like every copied worksheet to have a tabname that is identical with
the first but one number higher. I also would like a certain cell, in this
case I1, to follow that change in numbers and also be one number greater than
the sheet before it.

In other words:
I copy Sheet1 (not called "Sheet") with cell I1 reading "1".
I get Sheet2 with cell I1 reading "2".

Any help would be greatly appreciated.

Thank you,
Olle Svensson

Hi Olle. Try the McGimpsey and Associates site:
http://www.mcgimpsey.com/excel/event...efromcell.html. You may be
able to adapt this to your needs. HTH
--
Sincerely, Michael Colvin


"Olle Svensson" wrote:

Hello,

I am currently creating a template for some shipping documents and these
documents usually have about 30-40 identically formatted worksheets. Several
cells within the worksheets have to be entered manually, of course, but I
would like every copied worksheet to have a tabname that is identical with
the first but one number higher. I also would like a certain cell, in this
case I1, to follow that change in numbers and also be one number greater than
the sheet before it.

In other words:
I copy Sheet1 (not called "Sheet") with cell I1 reading "1".
I get Sheet2 with cell I1 reading "2".

Any help would be greatly appreciated.

Thank you,
Olle Svensson