Macro Assistance

[jurquhart]

Say I am trying to create a bill of materials list that generates, sorts and numbers according to pushbutton clicks after the user selects the vlookup values provided in a data set list of a drop down menu.

After I have randomly created these values I can add them to the bill, then sort them according to their numbering using a basic A-->Z sort, however I am struggling with trying to create a numbering and spacing system for these newly generated rows and parts with descriptions

Based off the 13th character in the part description I can pull out a sortable number, however I still need to number the parts using a start point of 1.1

so if I were to have 4 beams with the description:

-S4 X 7.7
-S5 X 10
-S6 X 12.5
-S6 X 17.25

I could number them accordingly:

SB1.1
SB2.1
SB3.1
SB3.2

and if i were to have another set of 4 beams with the description:

-S4 X 7.7 cs
-S4 X 9.5 ss
-S5 X 10 cs
-S5 X 10 ss

I want to sort it as the following:

-SB1.1
-SB1.2
-SB2.1
-SB2.2


Any thoughts on how I could do this?

I have tried value(mid(...) to work, but I am still not quite there, once I can figure out how to consistantly number them then I can code the macro portion of it to do a vlookup based on the number of rows added.

but in the meantime, any thoughts? I would really appreciate your help.