compare and copy
 

well i have a situation at my hand
i have two sheets. one has a list of 2000 item and the other has 375
i want to compare the sheetA 375 one with SheetB 2000.
if the column A matches the columnA of sheet2 then copy the values from
sheetB from column B thru F in to sheet A F thru L can someone please tell
me how to do this or if someone can write a macro for this as i dont know at
all how to write those macros

compare and copy
 

Hi Arain,
This page of Chip Pearson's should get you started
Duplicate And Unique Items In Lists
http://www.cpearson.com/excel/duplic...tractingUnique
along with the reference to "Duplicates" at the bottom of the article.

The word "I" is always capitalized, the contraction "don't" needs
the apostrophe before the "t", and the word "through" should really
be spelled out.-- "thru" is very informal.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Arain" wrote in message ...
well i have a situation at my hand
i have two sheets. one has a list of 2000 item and the other has 375
i want to compare the sheetA 375 one with SheetB 2000.
if the column A matches the columnA of sheet2 then copy the values from
sheetB from column B thru F in to sheet A F thru L can someone please tell
me how to do this or if someone can write a macro for this as i dont know at
all how to write those macros