Insert new row based on character within a cell

[bocrad75]

Hello,

I'm wondering if someone can assist me with this. I am looking for VBA code to insert a new row and copy down based on seeing a character after a semi-colon.

For example:

Current:

ID1 Hi;Hello;What;
ID2 There;This;That;
ID3 Wahoo;


Desired:

ID1 Hi;
ID1 Hello;
ID1 What;
ID2 There;
ID2 This;
ID2 That;
ID3 Wahoo;

I need column A to copy down to maintain the key and column B to insert and parse out only if there is a character after a semi-colon.

Any help would be greatly appreciated.

Thank you,
DB

[jindon]

try

Please Login or Register  to view this content.

[bocrad75]

Hi Jindon,

This works! I really appreciate the assistance.

Thanks again,
DB