find data that changed Wrote:
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???

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


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=393504