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