| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create 50 copies of a worksheet in the same file
In a sheet named: List,
enter (or paste over) the reference list of 50 sheetnames in A1 down The 50 copies will be created (from left to right) in the order that the names are listed in A1 down. So just sort the list in A1:A50 in the desired order before running the sub. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing a particular excel worksheet into another excel file | Excel Worksheet Functions | |||
| Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
| Create a copy in the same folder when a file is modified and saved | Excel Discussion (Misc queries) | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| why does excel create multiple copies (as many as 18) of a file? | Excel Discussion (Misc queries) | |||
Hybrid Mode
