Hello all,
Within the attached you will find two tabs: Master and Compare. The data within the Master tab is generated from a central database and the data in the Compare tab is my own personal file.
I am trying to compare the highlighted data within the Master tab with the highlighted date within the Compare tab to point out any differences between them and then show a side-by-side comparison in a new sheet with Master and Compare column headers. The data labeled N/A is not important for comparing purposes but will always remain in those specified columns.
Neither the Master nor Compare tabs contain the "correct" data. Some data for a certain entry will (and should) be different as the data is always changing. My goal here is to simply display which data differs from sheet to sheet. Any suggestions or ideas would be greatly appreciated!
Thanks,
Nick
Bookmarks