compare worksheets data
 

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

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

On Fri, 5 Aug 2005 17:19:02 -0700, "find data that changed" <find data
that 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???

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

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

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

That worked great Paul...Thanks!!!

"Paul Sheppard" wrote:


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