Multiple Row and Column Data Validation

[aultheman]

I recently took over the responsibility of a large excel spreadsheet that is accessible and updated by multiple users. I have been tasked to take the original version of the spreadsheet – 500 rows, 350 columns of data - and compare it to the current version and identify any and all changes. Does anyone have any recommendation on how I would accomplish this.

[ben_hensel]

To track changes going forward:
Review Ribbon => Changes Tab => Track Changes Dropdown => Highlight Changes. If you activate the "List Changes on a New Sheet" it will create a new tab called "History" that will create a table that will document all the changes made in the spreadsheet.

If you're looking to see what's different compared to an original worksheet:
I'd probably create two new tabs in the workbook with the tab of New data.
One tab would contain the Old data.
Third would just be filled with formulas like:

Please Login or Register  to view this content.

This will display all the values from the New tab that are different than the Old tab.

I don't know if you need more organization after you get to that point.

[aultheman]

Thanks for you reply Ben. I will give both options a try. Thanks again...