Forum Discussion
Looking for better ways to update excel master file from a daily new product export
EstherPhilippen Difficult to recommend based on imagination only, but I'll give it a try.
Power Query would definitely be the tool to use. Take your current master file and merge it (Left anti join) with the update file. That will leave you with all rows from the master that are NOT in the update file. That is, the 95% that didn't change. Now, you append the update file to the "95% master" to create a new master containing all old, updated and new rows. No VBA or complicated formulae needed.
EstherPhilippen Difficult to recommend based on imagination only, but I'll give it a try.
Power Query would definitely be the tool to use. Take your current master file and merge it (Left anti join) with the update file. That will leave you with all rows from the master that are NOT in the update file. That is, the 95% that didn't change. Now, you append the update file to the "95% master" to create a new master containing all old, updated and new rows. No VBA or complicated formulae needed.
Riny_van_Eekelen Thank you!
Indeed, hard imaging but it turned out to be even easier, as the system export contains all records with current values, so I didn't need to extract rows that didn't change. I only had to left outer join the system export file with the master, to create a new master in which I could delete all previous system columns.
I guess tomorrow I only need to replace the system export file and refresh the query 🙂
