If I have an original sheet comprising of 8 columns and a number of other row items with subtotals in between.
The next sheet contains the same format but an updated one with some numbers changing.
How can i get to know the changes made in the updated sheet from the original one.
The list contains only numbers and the top rows are fixed titles with alphabetical characters. Same is the first Column with alphabets titles.
Others are numbers and subtotals generated using formulas.
I would be extremely grateful to get the desired issue solved.
if position of numbers do not change, you can compare via formula easily or even side by side. How ever if the position of number do change, then what two totals ( one from each sheet) or subtotals need to be compared needs to be answered and determined.
Can these numbers and subtotals get highlighted once the comparison is done automatically?
Mean to say is i need to compare the whole sheet and only the changed value should get highlighted.
Is there any direct comparison method.