Compare two sheets in VBA

[followme23]

Hello I would like to compare two sheets. The sheets have item numbers that differentiate the rows. What I want to do is first find if the item number exists on both sheets and if it does compare a quantity, not the item number. If the quantity matches do nothing is it does not match I would like to display the entire line in a new sheet. Thank you for your help.

 

[hiker95]

followme23,

Welcome to the MrExcel forum.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data worksheets, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com