Tip to make batch individual construction proposals (using our template) from master list

Could you attach a sample workbook with sample data and explain in detail what you want to do using a few examples form your data and referring to specific cells, rows, columns and worksheets? The sample workbook should be an exact representation of how your data is organized.

Thank you for the files. It looks like you want to populate K13:K17 of the Proposal sheet with the corresponding data from the Master. If this is correct, there are 6 rows of data in the Master. How do you determine which of the 6 rows in the Master to use to populate the Proposal?

If you are going to have multiple rows in the Master then I think it would be best if we can come up with a way to select the specific row containing the data you want to export to the Proposal. I don't think that trying to adapt the code for one row to handle a Master with 400+ rows will work. It looks like the OVP ID and the TERM ID for each job are unique values. If this is true, then we can use the unique value for each row to identify the row. The macro could prompt you to enter the unique ID and then proceed to export the data for that row to the Proposal. Will that work for you? You could also have the macro export the data for all the 400+ jobs all at once giving you 400+ Proposals.

Have a look at the attached files. In the "Proposal" sheet I have unmerged the range K13:K18. You should avoid using merged cells at all cost because they create havoc for macros. When you run the macro it will prompt you to enter the Term ID for the job you want to import. I assumed that the Term ID's are unique. Make sure both workbooks are open before you run the macro.