Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.office.misc
|
|||
|
|||
Faster way to duplicate worksheet with sequence ???
Hi there
I am using Excel 2002. I have one worksheet tab named "Product 1" (which is the same data as I typed in cell A1). I wanna make 20 copies of this worksheet and name them from "Product 2", "Product 3".... all the way till "Product 21" Questions: 1) is there a faster or easier way to copy/duplicate 20 copies of the worksheet? 2) I also want the worksheet name appears in cell A1 respectively i.e. Worksheet Product 2's cell A1 is "Product 2", Worksheet Product 3's cell A1 is "Product 3" etc etc.... How can I do that? Thanks. cheers |
#2
Posted to microsoft.public.excel.misc,microsoft.public.office.misc
|
|||
|
|||
Faster way to duplicate worksheet with sequence ???
Hello,
Try my add sheet utility at http://www.geocities.com/excelmarksway There are two of them. AddSheets.xls or InReMo.xls The last one is a bit more advanced. It gives you the option of creating as many sheets as you want. And naming them to whatever ie Product1, Product2, etc also dates in any format .... " wrote: Hi there I am using Excel 2002. I have one worksheet tab named "Product 1" (which is the same data as I typed in cell A1). I wanna make 20 copies of this worksheet and name them from "Product 2", "Product 3".... all the way till "Product 21" Questions: 1) is there a faster or easier way to copy/duplicate 20 copies of the worksheet? 2) I also want the worksheet name appears in cell A1 respectively i.e. Worksheet Product 2's cell A1 is "Product 2", Worksheet Product 3's cell A1 is "Product 3" etc etc.... How can I do that? Thanks. cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
Update Worksheet to Worksheet | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |