Modify a line into several lines

**jaslake** · 06-07-2010, 10:39 AM

Hi julien4266
With the code in the attached workbook, if you have more units than you have tags, the units without tags are assigned a tag value of "Spare" and all unit quantities are changed to 1.
Let me know of issues.
John

**julien4266** · 06-07-2010, 08:50 PM

Originally Posted by jaslake

Hi julien4266
With the code in the attached workbook, if you have more units than you have tags, the units without tags are assigned a tag value of "Spare" and all unit quantities are changed to 1.
Let me know of issues.
John

At the first sight it seems perfect to me. Thanks you very much for your help.
Well done.

**jaslake** · 06-07-2010, 09:33 PM

Hi julien4266

Glad you're pleased. If you're satisfied with the solution, please mark your post as "SOLVED". If you're so inclined, click on the scales for style points. It's been a pleasure.

John