Copy & Paste According to Reference

Hi Community,

I have some data from a query which I expand upon, however after expanding it is missing some data from the source. Since the data is dynamic (from the query), I can't use a record macro function to copy and paste the missing values!

In the attached workbook I'm missing some data which can be found in the "source" sheet; specifically Id, travel end date, opportunity reference number and opportunity sequence number. I'm sorry if this is a little confusing so I attached a "expected result" to see what I mean!

Thank you!

Re: Copy & Paste According to Reference

Thanks for the reply, I didn't think it was important to include, all I did to go from source to after expanded is import the html code (column E) into internet explorer and export it back into excel as a table as well as some simple macro formatting.

Re: Copy & Paste According to Reference

Thanks for the reply, the id columns are not included in the import so to match them I tried using string searching and using offset but I can't get the ids to match the reference numbers. This would be fairly simple if it was a static list, but since it is dynamic I can't search for these specific id's. Perhaps some grouping method? Or some better string searching?