Leeward904
New Member
- Joined
- May 5, 2021
- Messages
- 12
- Office Version
- 2019
- Platform
- Windows
I have seen quite a few threads that are similar to what i need to accomplish but none of them are quite the right solution.
I have a workbook that i use to create cost estimates for contracts i am bidding and it is the same template for each job. The basic set-up is a tab in which i put each work item number, title, and either "base" or "option" that is used to populate the "Bid Overview (PTW)" tab. Once all of the work item information is populated i have a button with a macro that creates a new tab for each work item in the list and applies the corresponding information and finally names the tab the work item number (ie 123-11-001). Each new worksheet is created exactly the same using the template i have on the tab titled "Estimate Template" so all the data that is entered in each work item tab is always located in the same cells.
Now what i can't seem to figure out is how to write the macro that i would assign the button on the "Bid Overview (PTW)" tab that will loop through the work item tabs and copy the data in the specific cells A12 - M12 and pastevalues them to the corresponding cells for that work item on the bid overview tab.
The work item tabs always are created to start after the "yard Support" tab or tab 10.
I can't attach my workbook to this post but i have attached some photos and would be more than happy to send the whole workbook if someone tells me how to send it or attach it...
I would be forever in your debt if anyone could provide the answer to my issue!
I have a workbook that i use to create cost estimates for contracts i am bidding and it is the same template for each job. The basic set-up is a tab in which i put each work item number, title, and either "base" or "option" that is used to populate the "Bid Overview (PTW)" tab. Once all of the work item information is populated i have a button with a macro that creates a new tab for each work item in the list and applies the corresponding information and finally names the tab the work item number (ie 123-11-001). Each new worksheet is created exactly the same using the template i have on the tab titled "Estimate Template" so all the data that is entered in each work item tab is always located in the same cells.
Now what i can't seem to figure out is how to write the macro that i would assign the button on the "Bid Overview (PTW)" tab that will loop through the work item tabs and copy the data in the specific cells A12 - M12 and pastevalues them to the corresponding cells for that work item on the bid overview tab.
The work item tabs always are created to start after the "yard Support" tab or tab 10.
I can't attach my workbook to this post but i have attached some photos and would be more than happy to send the whole workbook if someone tells me how to send it or attach it...
I would be forever in your debt if anyone could provide the answer to my issue!