I have 2 large spreadsheets of data with ~40 columns each. (essentially a before/after look at data) The columns are identically named/positioned. I'd like to create a workflow that compares all data for a given row in spreadsheet 1 with spreadsheet 2. The rows in each spreadsheet may not be the same. (i.e. row 5 in spreadsheet 1 might actually match row 7 in spreadsheet 2).
I thought I'd be able to do this relatively easily but I'm a bit of a novice and this is proving more difficult than I thought. I'm hoping that this is easy as I think it is but would appreciate any guidance you can provide.
Thanks
