nancy.darnell
New Member
- Joined
- Jul 19, 2007
- Messages
- 6
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
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