Copied VBA code won't work.

Hello,

With the help of this forum i created a piece of code that searches, matches and copies values. Its working fine. here's the code:

Please Login or Register  to view this content.

Now I'm trying to copy and change the code so an other value is searched, here is the code I created.

Please Login or Register  to view this content.

The code is working fine, the first item is found, matched and placed in the right cell, only the code give's an error at the end "Loop While c.Address <> firstaddress"

Does anyone has got an idea? the code is working in the first part but not in the second.

Thanks in advance

ABBOV

Using advancedfilter would have the same result with a minimum of VBA-code

Please Login or Register  to view this content.