Merging/Updating Two Excel Workbooks

[ajcormac]

Hello,

I want to 'merge' excel 2013 data from two different workbooks (Internal & External) into a third excel workbook (Merged). The unique identifier will be ID and if there is no survey (external) data for an ID, then the row will only contain Internal information.

The catch is that the survey data will have rows added and updated frequently (Part Two) and I would like for the Merged Table to automatically update (if possible?). However, if a row is simply updated (as in Part Two), I would like for Excel to check for an existing Date/Completion and if one exists, "push" it back and store the new one as well. This is the reason for Survey Date_2 and Completed_2.



Part One: Before Survey Data is updated

Part I.png

Part Two: After Survey Data is Updated

Part II.png



I am willing to clarify any parts of this if need be and thank you in advance for any & all help.

[noboffinme]

Hi ajcormac,

You could create Pivot tables from your source data & then create a consolidated Pivot that makes a Pivot containing all your fields based on the ID field.

Can you post the excel files?

Thanks