Hi everyone,

Long time reader, first time poster.

I have a Power Query (Main Verification Query) which collects data from a dozen spreadsheets, appends them into a table (TBL_Main_Append_Query), and each record has a unique ID. Unfortunately, the Unique iD is specific to each original spreadsheet, and does not run consecutively.

I have a second table (TBL_Verification) which has a data validation list looking-up the unique ID. This is where the data is validated by agents and comments are added in the Verification table. I have created a relationship between the two tables so I can query them together later.

When the query is refreshed, the data no longer aligns between the two tables (no surprises there). I need a code that compares the Unique IDs and inserts rows in the 2nd table so the two tables align the data based on the IDs.

Short of Power BI, I have reconfigured this numerous ways but can't seem to get it to do what I need. I think VBA is the only way for me to go, unless someone has a brilliant insight that I have missed!

If anyone can help, it would be greatly appreciated.

Thank you