compare worksheets data

[Guest]

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???

 

[Paul Sheppard]

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???

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

 

[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???

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

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

 

[Guest]

That worked great Paul...Thanks!!!

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