Hi,
I'm fairly new to Excel, not really used it too much. I was wondering if there's a way to automatically compare 2 workbooks, so that Excel reads back to you the differences between the 2. For example, a row on the first book might read:
1 3 5 7 9
And the same row on the second reads:
1 3 4 8 10
So, Excel would read to me (Assuming 0 is no change)
0 0 -1 +1 +1
Something along those lines? I don't even know where to begin looking for answers!
Many thanks in advance.
Bookmarks