Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the value of a cell when a condition is satisfied, but not otherwise? | Excel Discussion (Misc queries) | |||
How to change reference to other worksheet by changing one cell? | Excel Worksheet Functions | |||
Cell Change Color - Need Help | New Users to Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Cell references change when entering new data | New Users to Excel |