Split data from one cell into two new rows

Hi Guys,
I have a spreadsheet which includes a number of product codes in column B, some of which display two codes in one cell with the second code inside brackets. I need a macro that identifies when a cell contains brackets and then inserts two rows below, the first to be filled with the first product code not in brackets, and the second row to be filled with the second product code which is inside brackets. The empty cells to the left and right of these new cells need to be populated with the data from the original row.
I have attached a spreadsheet with two tabs, one for before and one after to show you what I mean as I'm sure I’ve just confused you…

Try

Please Login or Register  to view this content.

Originally Posted by ports83

Jindon, The code you've provided doesn't work with my spreadsheet as my sheet names are not constant. The Data on the example I provided is accurate, however the workbook/worksheet structure is not.

That's your problem. not the code.

Please Login or Register  to view this content.