I want to copy several worksheet ...

D

Dr. Darrell

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I wnat to copy several Worksheets, Several Times... 11
Cannot copy worksheet to another file 2
Copy Worksheet 1
Copying worksheets into a new workbook changes information on shee 0
Copy rows to new sheet based on value in column A 0
Populate central worksheet template from multiple worksheets 0
Need Help With Macro to set a value in new sheets 2
make copies of worksheet for each day of month 1

Top