Hi,

I have a deadline to meet and need to put this together quick.

Column A has a list of serial numbers.

Next to every serial number (Column B), are several names separated by semi-colons.

Example:
456789 john; mary; bob
343400 gary, frank
230200 fisher; john; harry; ron
545777 john

I would like to make a macro that takes the names in column B and separates them line by line. There will always be a semicolon separating the names.

Result:
456789 john
456789 mary
456789 bob
343400 gary
343400 frank
etc

Please help? I don't know where to start.
Thanks!