Compare data in 2 excel sheets?

[chompy]

Hi,

I was wondering if some could please help me...

I have 2 spreadsheet in 1 excel work book that I need to compare and output the difference.

<table width="201" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:48pt" width="64" height="20">Sheet 1</td> <td style="width:103pt" width="137">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">23</td> <td> Test 1</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">1145</td> <td> Test 2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">675</td> <td> Test 3</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">1231
</td> <td>Test 4</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">320</td> <td> Test 5</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Sheet 2</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">24</td> <td>Test 1</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">1145</td> <td>test 2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">675</td> <td>the text has changed</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">1231</td> <td>Test 4</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">219</td> <td>Test 5</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">111</td> <td>new text</td> </tr> </tbody></table>
So as you can see in the 2 columns I have numbers(SKU) and text(SKU Description) that i need to compare with the 2nd sheet.

I can not seperate the SKU from the SKU Description, althought they are in 2 seperate columns.

So as an output I would need some thing like;

<table width="201" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:48pt" width="64" height="20" align="right">23</td> <td style="width:103pt" width="137">Test 1</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">675</td> <td>the text has changed</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">219</td> <td>Test 5</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20" align="right">111</td> <td>new text</td> </tr> </tbody></table>
So the output only displays the SKU Description that has been updated and if additional SKU have been added to the list.

Many thanks,

Matt

 

[chompy]

Guys, could really do with your help with this issue.

Many thanks,

Matt

 

[VoG]

Maybe this could help you http://download.cnet.com/Excel-Overlay/3000-2077_4-10963782.html

 

[chompy]

Thanks

But it does not do excatly what I need. It seems to use row numbers and diff between the 2 rows and not the ID numbers in the first column.

Anypne else have an idea how I can solve this?

Thanks,

Matt