Comparing two spreadsheet data

Closed
Report
Posts
4
Registration date
Saturday January 12, 2013
Status
Member
Last seen
January 25, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
Please help me out on this issue.

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.

Thank you in advance.

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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.
Posts
4
Registration date
Saturday January 12, 2013
Status
Member
Last seen
January 25, 2013

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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
if you have a surety that cells position will not change, then you can use conditional formatting to change color. again as i said all depends if positions are fixed or not
Posts
4
Registration date
Saturday January 12, 2013
Status
Member
Last seen
January 25, 2013

yes the cell position donot change... they are same as before..
occasionally one or two titles get changed which i get reported in advance.

what in that case then. will conditional formatting work
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
could you post a sample workbook at some public file sharing site like speedyshare.com and post back here the link to the actual file itself back here to help in seeing what u want