Macro for comparing two spreadsheets
 

Hello,

I have two excel spread sheets (say Sheet1 & Sheet2). Sheet1- is th
master spread sheet and Sheet2 is smaller spread sheet with very fe
details.

Suppose Column B in Sheet2 has 100 partnumbers and Column C in Sheet
has the superset of partumbers (1000) and corresponding details fo
each part number, I need to:

1. Check if all the 100 part numbers in Sheet2 has a correspondin
match in Sheet1
2. Extract the info for the matched partnumbers from Sheet1 and list i
a seprate sheet.
3. Even if there in no match Sheet1, let's say for 40 of them, i
should 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

--
Sunn
-----------------------------------------------------------------------
Sunny's Profile: http://www.excelforum.com/member.php...fo&userid=1488
View this thread: http://www.excelforum.com/showthread.php?threadid=26554

Macro for comparing two spreadsheets
 

have a look at synkronizer addin. www.synkronizer.com


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Sunny wrote:


Hello,

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

Suppose Column B in Sheet2 has 100 partnumbers and Column C in Sheet1
has the superset of partumbers (1000) and corresponding details for
each part number, I need to:

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

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

Thanks

Sunny