Specific cell change for copied sheets..?
 

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

Specific cell change for copied sheets..?
 

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