Search & retrieve data between sheets

**brisser90** · 08-17-2012, 02:23 PM

In my worksheet, I have 2 sheets that I'm working with, "Daten" and "Highlights (2)", and I want to search for a list of part #s on "Highlights (2)" in "Daten" that has part #s and data that corresponds to those #s. The part #s in "Daten" have several copies of each part #. The part #s in "Highlights (2)" are in column "A" and start on the 2nd row. The part #s in "Daten" are in column "B" and start on the 2nd row. Once the part # is found in "Daten", I want to copy the contents in column "D" in the same row over to "Highlights (2)" corresponding part #s row in column "E". The number of part #s change on a week to week basis. I've gathered code from several sites because of my basic understanding of VBA, and tried to piece it together as best as possible. I'm getting several errors that involve the Range function esp. Error 1004.

Here is the code I've put together:

Please Login or Register  to view this content.

**arlu1201** · 08-17-2012, 02:27 PM

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

**tigeravatar** · 08-17-2012, 02:40 PM

brisser90,

Welcome to the forum!
Give this code a try:

Please Login or Register  to view this content.

**brisser90** · 08-17-2012, 02:48 PM

Tigeravatar,

Your code works, thanks! If you have the time could you put descriptions in for some of the code so I know what the code is actually doing so I can learn what you did?

arlu1201,

Sorry about the code tag, thanks for fixing that. I'll make sure to do that in the future.