I have 1 Workbook with 2 seperate sheets. On Sheet 1 Column A is about 13500
par numbers on Sheet 2 Column A is about 12500 Part numbers and Column B is
Item Name.

How can I compare Sheet1 Column A to Sheet 2 Column A?

How can I compare Sheet 1 Column A to Sheet 2 Column A and then see the ones
that are not the same?

Can I have excel match Sheet 1 Column A to Sheet 2 Column A and if they
match brng the information in Column B over to sheet 1 for the matches?

Or am I asking for to much?