Could finally get what you wanted? If not and still want some help why
don't you give exact layout of your sheet eg.

Row1 Headers
Col A PartNO
Col B Desc
Col C ...
Col P Model Names
etc
You said model starts only from col P but then you also said it is col
9 which is confusing. And in your desc you have shown models separated
by "," and we are all assuming that all model names (for a row of a
part number ) are in one cell separated by ",". Is that true? eg we
assume a2 has "7V4325", B2 has " Bolt " and C2 has " Cabrio, Golf, GTI
". Is that what you meant? Or you meant model names start from Col C
and thus C2 has "Cabrio", D2 has "Golf" and E2 has "GTI"? Also would
you require help to know as to where to copy the procedure and how to
run it? I know it is very basic but I got stuck here when I started
with VBA programming.

A V Veerkar


--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338
View this thread: http://www.excelforum.com/showthread...hreadid=510236