-
Code for copy/paste from list to new sheets
I don't use VBA that much and really need to figure this out. I need to create a macro that will perform the following steps:
1. Select sheet "Trigger"
2. Copy Sheet Name from a list starting in "AV42"
3. Go to sheet "PDR"
4. Rename Sheet copied from step 2 above
5. Select sheet "Trigger"
6. Copy Title from a list starting in "AR42"
7. Go to sheet that was recently renamed
8. Paste Title into cell A1
9. Select sheet "Trigger"
10. Copy Description from a list starting in "AS42"
11. Go to sheet that was recently renamed
12. Paste Description into cell B1
13. Copy sheet to New Sheet
Repeat 1-13
This can be done in 3 different loops if that's easier
1. Copy Sheet Multiple times
2. Copy/Paste Title from list to new sheets
3. Copy/Paste Description from list to new sheets
Can someone please provide the code to accomplish these tasks?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules