I am needing some help please. I have attached two separate workbooks ("Templates") --Monitoring Report and Analytical Data.
1. I upload the analytical data to the Analytical Template (which does have formulas in columns C & E - S).
What I need is:
2. I need to copy the final data from columns B - S of the Analytical Data WB - ABC Stage WS
and Paste that data (as numbers, not as formulas) to columns H - Z of the Monitoring Report WB - Treat Summary WS
a. There may be data in columns B - G of the Monitoring Report, which will need to stay intact (as is)
b. The pasted data will need to copy to the row that matches the names from column A of the Analytical Data to column A of the Monitoring Report.
Column A of the Monitoring Report - Treat Summary WS (beginning at Cell A9) has a list of 5 well names
AAA-1, AAA-2, LuLu, 1-12 5WA, 1-12 3BS
Column A of the Analytical Report - ABC Stage WS (beginning at Cell A2) has a list of 4 well names
AAA-1, AAA-2, 1-12 5WA, 1-12 3BS
I need the data from the AAA-1 data in the Analytical Report to upload the the row that has AAA-1 of the Monitoring Report
I tried to write the following macro, but it is not running the way I had hoped:
I appreciate your help and time in resolving this request.