Forum Discussion
Excel Help Needed – Linking sheets without dynamic sort and filter
Hello Excel Community! I’m reaching out for some advice on automating data flow between two Excel spreadsheets, and I’m facing a challenge that I can’t seem to overcome. Here’s the situation: I ha...
I would use a 'self referencing query in Power Query' (PQ). Google for it and you'll find many sources that explain the process. It allows you to connect to the Employee Master and pick-up all the changes upon a Refresh. The next step will be to add (in PQ terms "merge") back the columns that were added by Finance in the previous version of the extracted master data, based on the employee ID. The attached workbook contains a working example.