Leeward904
New Member
- Joined
- May 5, 2021
- Messages
- 12
- Office Version
- 2019
- Platform
- Windows
Hey everyone,
I have seen a couple threads discussing this but all are slightly off from what i need to accomplish.
I have a MACRO that creates additional worksheets based on the template worksheet and fills in the title for each new tab and applies the corresponding information to each new worksheet. Now what i need to do is have another MACRO that once these new sheets are created, each sheet needs to show the data in cells A12 - M12 to the corresponding "summary" worksheet. I have attached the pictures of each sheet to help explain i if have made it confusing...
Basically the sequence is:
1. once the additional worksheets (work item estimate) are created using existing MACRO the tabs are completed with the hours/material-sub dollars
2. once all of the work item estimates are completed and the data needs to be imported to the summary tab. I would like to have a button control for the workbook to pull the data from each work item tab to the summary sheet.
I have seen a couple threads discussing this but all are slightly off from what i need to accomplish.
I have a MACRO that creates additional worksheets based on the template worksheet and fills in the title for each new tab and applies the corresponding information to each new worksheet. Now what i need to do is have another MACRO that once these new sheets are created, each sheet needs to show the data in cells A12 - M12 to the corresponding "summary" worksheet. I have attached the pictures of each sheet to help explain i if have made it confusing...
Basically the sequence is:
1. once the additional worksheets (work item estimate) are created using existing MACRO the tabs are completed with the hours/material-sub dollars
2. once all of the work item estimates are completed and the data needs to be imported to the summary tab. I would like to have a button control for the workbook to pull the data from each work item tab to the summary sheet.