Comparing two spreadsheet data

Closed
vikas.nandanwar
Posts
4
Registration date
Saturday January 12, 2013
Status
Member
Last seen
January 25, 2013
- Jan 23, 2013 at 11:46 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jan 26, 2013 at 10:16 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jan 24, 2013 at 06:55 AM
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.
0
vikas.nandanwar
Posts
4
Registration date
Saturday January 12, 2013
Status
Member
Last seen
January 25, 2013

Jan 24, 2013 at 10:56 PM
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.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jan 24, 2013 at 11:01 PM
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
0
vikas.nandanwar
Posts
4
Registration date
Saturday January 12, 2013
Status
Member
Last seen
January 25, 2013

Jan 25, 2013 at 12:56 AM
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
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jan 26, 2013 at 10:16 AM
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
0