Compare a column in two sheets and copy and paste into one

[nancy.darnell]

I need help creating a macro to perform following:

I have two excel sheets One is called "upload_data" and the "query1".
I want to compare one column called "product_id" in both sheets. They are in different order in each sheets. After comparing and finding the right "product_id" in "query1" sheet. I want to copy the data from "Description" column in "query1" to paste into "upload_data" sheet "Description". Please let me know how to do this. thanks

Nancy

 

[ravishankar]

Hi

Assuming product ID in col A, descriptin in Col D
In upload_data sheet description column you can insert the formula
=vlookup(A1, query!A1:D100,4,false) and drag it till the end of data

if you want a macro, Paste the following codes in the macro window ( alt F8)

x= worksheets("upload_data").cells(rows.count,1).end(xlUp).row
for a = 1 to x
cells(a,4) = application.worksheetfunction.vlookup(cells(a,1), worksheets("query1").range("A1:D100"),4,False)
next a

Run the macro
Ravi

 

[nancy.darnell]

Thanks, it works great.

Nancy