Hi,

I am trying to adopt the macro you created back in March 2006, and was having some hard time revise it to meet my needs (help!!!) My problem is that I want to need the first 4 columns in every row = sName instead of just column A.

The second problem is that serial numbers in column A starts with zeros, and when they are copied to the oOut spreadsheet, the zeros are all gone due to the cell format. Please advise how I can define the cell format (i.e. selection.numberformat = "@") in the new spreadsheet!

My spreadsheet currently looks like this:

Procedure Description Category Price Modifier1 Modifier2
001234 Plastic bag V $12 TC890 TC990
001235 Paper box V $15 TB003
001236 Tin can J $20 TC999 13556

I would like to use the splitrow() and convert the spreadsheet into:

Procedure Modifiers Description Category Price
001234 TC890 Plastic bag V $12
001234 TC990 Plastic bag V $12
001235 TB003 Paper box V $15
001236 TC999 Tin can J $20
001236 13556 Tin can J $20

Thank you very much in advance,
egghi