Check values seperated by comma, if matches copy cells

Hi!

Since I'm new to VBA I'm looking for a code to solve the following problem:

There are two Worksheets in the attached Excel-File called "Inventory" and "Location".

As soon as there's an entry in row D of the sheet "Location", the value of the 12 left characters of the entry should be compared with the data of row A in sheet "Inventory". If it matches an inventory-number, the rows A, B, C and E in the line of the compared numer in sheet "Location" should be copied to the rows E to H in sheet "Inventory". This should also work for possibly more then one entries per cell, seperated by comma in row D of sheet "Location".

I hope i could explain my needs for everyone to understand, though english is not my native language.

thanks
dervish65

Problem solved!

Thanx to Carsten from Bremen!

Here's his perfectly working Code for my Inventory-List:

Please Login or Register  to view this content.

Regards
dervish65