Find matching cells on two worksheets, then copy the data over

[ScorpioX]

Ok here we go. Not sure I'm explaining this right. So I will try the best I can.
I have Two Worksheets within the same Workbook. One is named Sheet1 the other is Sheet2. Sheet1 Has six columns (A, B, C, D, E, F)with 1000 rows. Sheet2 Has three columns (A, B, C) with 2000 rows. I would like to search Sheet2 column A, for the matching value in Sheet1 column D. If Sheet2 column A matches a cell in Sheet1 column D. Copy the data from Sheet2 column B and C into Sheet1 column E and F. Then delete the entire row from Sheet2. Can this be done?

Any help would be appreciated greatly,
Scorpiox

 

[xlbo]

This looks like a task for VBA!

Please post in VBA forum: Forum707

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[tammy23]

Did you ever get help with this?? I have been working on kind of the same thing and MAY be able to help...I emphasize may because I am really new to VBA....

 

[ScorpioX]

Hi Tammy23,
Yes actually I did get help with this. I ended up using a query to do it. If you have VBA code that does it. I would be interested in looking at it. If you need my help feel free to ask. Basically the query was pretty simple. I added the two tables joined them using the same field. Then added the data I wanted to copy to a blank sheet. Worked like a charm.

Scorpiox