compare worksheets data

  • Thread starter find data that changed
  • Start date
F

find data that changed

I have two work sheets, version 1 and version 2. I am trying to identify
what changed. The data is as follows:

Invoice # Item # Amount
11111 aaaaa 1.00
11111 bbbbb 2.00
22222 aaaaa .50
22222 bbbbb .75
33333 bbbbb 1.00
44444 ccccc 1.00

Can anyone help???
 
P

Paul Sheppard

find said:
I have two work sheets, version 1 and version 2. I am trying t
identify
what changed. The data is as follows:

Invoice # Item # Amount
11111 aaaaa 1.00
11111 bbbbb 2.00
22222 aaaaa .50
22222 bbbbb .75
33333 bbbbb 1.00
44444 ccccc 1.00

Can anyone help???
Click to expand...

Add a third worksheet and use the following formula

=IF(Sheet1!A1=Sheet2!A1,"No Change","Changed")

you need to change sheet1/sheet2 in the formula to matcch the names o
your worksheets

If invoice # is cell A1, then start from there, then drag the formul
down and across as far as required

All the cells with Changed in them are the ones you are looking fo
 
H

Hank Scorpio

I have two work sheets, version 1 and version 2. I am trying to identify
what changed. The data is as follows:

Invoice # Item # Amount
11111 aaaaa 1.00
11111 bbbbb 2.00
22222 aaaaa .50
22222 bbbbb .75
33333 bbbbb 1.00
44444 ccccc 1.00

Can anyone help???
Click to expand...

There's an add-in called Compare.xls that you may find useful. See:

http://www.cpearson.com/excel/whatsnew.htm
 
D

Dan

That worked great Paul...Thanks!!!

Paul Sheppard said:
Add a third worksheet and use the following formula

=IF(Sheet1!A1=Sheet2!A1,"No Change","Changed")

you need to change sheet1/sheet2 in the formula to matcch the names of
your worksheets

If invoice # is cell A1, then start from there, then drag the formula
down and across as far as required

All the cells with Changed in them are the ones you are looking for
Click to expand...
 
Top