compare and copy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Arain,
This page of Chip Pearson's should get you started
Duplicate And Unique Items In Lists
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro needed 2
Arrays containing variable sheets 2
Moving data from one spreadsheet to another 4
How do I join two excel sheets? 1
Copy relative formula across sheets 5
copying multiple worksheets to a new workbook 2
comparing values 2
Copy worksheet to another workbook 1

Back
Top