macro for comparing fields in two work books

  • Thread starter Thread starter Sunny
  • Start date Start date
S

Sunny

Hello,

I have two excel spread sheets (say A1 & A2). A1- is the master sprea
sheet and A2 is smaller spread sheet with very few details.

Suppose Column B in A2 has 100 partnumbers and Column C in A1 has th
superset of partumbers (1000) and corresponding details for each par
number, I need to:

1. Check if all the 100 part numbers in A2 has a corresponding match i
A1
2. Extract the info for the matched partnumbers from A1 and list in
seprate sheet.
3. Even if there in no match A1, let's say for 40 of them, it shoul
still list those parts in the new sheet.

Can anybody help me with this problem. I would really appreciate i
anybody can suggest any tips.

Thanks

Sunn
 
Chip Pearson has lots of techniques at:
http://www.cpearson.com/excel/duplicat.htm

(and you may want to use sheet names like Sheet1 and sheet2 (or book1 and
book2). A1 and A2 look a lot like addresses of ranges. It's not too confusing
in this example, but it can get confusing pretty quickly.)
 
Back
Top