| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outlining based on level numbers in most left column
Hi,
I have a table, which is downloaded from SAP and has no formulas. The identifier of the rows is a project item number like "PRD. 00133.07-03-04" and I count the number of "." and "-" with a formula to get the level of the project item. My goal is now to make an outline by vba using the level numbers, e.g. 4 in the case described above. The first row of the table is poulate with these level numbers like 1 2 2 3 3 2 1 2 and so on. Does anyone have a vba procedure to solve this problem. Thanks. Excel XP SP3 Windows XP SP3 Best Regards Werner |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Addition based on left column | Excel Discussion (Misc queries) | |||
| How Outlining w/o numbers possible? | New Users to Excel | |||
| Unhide column based on subtotal level open. | Excel Discussion (Misc queries) | |||
| Outlining - collapse rows based on repeated column value | Excel Discussion (Misc queries) | |||
| strange column to the left of my row numbers column | Excel Discussion (Misc queries) | |||
Threaded Mode
