| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I wnat to copy several Worksheets, Several Times...
I have 17 work sheets in one workbook all labeled similar to this; <<< Item
00001, 3" Valve I want to do the following: 1) Copy each work sheet 4 times. a. Rename the originals with an appendage of 1 Ea; <<< Item 00001, 3" Valve b. Rename each of the copies with an appendage of 5 Ea, 10 Ea and 20 Ea 2) Change the value of Cell M8 in each new worksheet to be 5, 10 and 20 to correspond to the names of the new worksheets. I know how to do this by copying the worksheets and renaming them and typing the value into M8. Can this be easily done through VBA and what should I use for code? Darrell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding times on different worksheets in same file | Excel Worksheet Functions | |||
| wnat to extract first & last names in sep cols from name list in 1 | Excel Worksheet Functions | |||
| Bold and formated cell wnat to delete in one stroke | Excel Discussion (Misc queries) | |||
| How do i use the same name multiple times in repeating worksheets | Excel Discussion (Misc queries) | |||
| Count # of times value "x" appear across multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
