Outline format

I am creating a directory with categories: main, Sub-category, sub-sub-category. It should look liek this"
1.0 Main Item x
1.1 Sub-category x
1.1.1 Sub-Sub-category x



The x's are manual insertions n a specific column or box in a form, but when a new main category is added the outline number (1.0) needs to automatically shift to 2.0 and iif a sub-category is entered ti needs to shift ot 1.2 or 1.3, etc. The same holds true for sub-sub-categories. So it may very likely end up looking something like this"

1.0 Main Category x
2.0 Main Category x
2.1 Sub-Category x
2.2 Sub-Category x
2.2.1 Sub-sub-Category x
2.3 Sub-Category x
2.3.1 Sub-Sub-Category x
3.0 Main Category, etc. x

I've discovered that I can label individual columns with 1.0, 1.1, and 1.1.1 and extend them by highlighting two cells and dragging the lower right corner, but I need to create the format that will work automatically and re-start new numbers (3.1 at 3.1, not a contimuation of the last in the column or jumping to 4.0 after it reaches 2.9) . Thank you for your help.

Mark

Hi, I assume the Text "Main Category" etc is in column "B" with the Ref Number in Column "A" , if so try this.
Code inserts Numbers in column "A"
NB:- Make sure you The Words "Sub" in your list, starts with an upper Case, Some or your are Lower.

Please Login or Register  to view this content.

Regards M8ick