Been trying for hours to figure this out. I receive 2 daily reports (same format/headers, unique entry numbers) but the info may be updated and new rows of data added. Master sheet columns A to Z show the report data, but columns AA to AZ contain static data added manually corresponding to the data in A to Z.
How can I merge the data from sheet1 and sheet2 into the Master (I copy and paste over previous reports with new report) and still have the data match up to the static info? Also new data rows would need to be added to the next open row. I am not well versed in VBA, before the static data was required vlookup worked, but not in this case.
Thanks in Advance!
How can I merge the data from sheet1 and sheet2 into the Master (I copy and paste over previous reports with new report) and still have the data match up to the static info? Also new data rows would need to be added to the next open row. I am not well versed in VBA, before the static data was required vlookup worked, but not in this case.
Thanks in Advance!
