Leeward904
New Member
- Joined
- May 5, 2021
- Messages
- 12
- Office Version
- 2019
- Platform
- Windows
I apologize if this has been posted in another discussion, I can't seem to find it...
I have the VBA macro to create new templated worksheets and name each sheet based on a master list. What I can't quite figure out is how do I include the next step to copy and paste the data from the same master list into the specific cells on each new templated worksheet.
Example:
Step 1- VBA creates a new worksheet based on the template for each specification number in Column A of the attached picture
Step 2- Each new worksheet is titled the number of each specification in Column A
Step 3- I need the macro to also copy the specification number for the corresponding worksheet into cell B1, the Spec Title into the corresponding worksheet into cell B2, and finally copy the corresponding word "Base/ Option" into the corresponding worksheet into cell B3.
I really appreciate any support anyone can provide as I am stuck!
I have the VBA macro to create new templated worksheets and name each sheet based on a master list. What I can't quite figure out is how do I include the next step to copy and paste the data from the same master list into the specific cells on each new templated worksheet.
Example:
Step 1- VBA creates a new worksheet based on the template for each specification number in Column A of the attached picture
Step 2- Each new worksheet is titled the number of each specification in Column A
Step 3- I need the macro to also copy the specification number for the corresponding worksheet into cell B1, the Spec Title into the corresponding worksheet into cell B2, and finally copy the corresponding word "Base/ Option" into the corresponding worksheet into cell B3.
I really appreciate any support anyone can provide as I am stuck!