I have a 21000 line bill of material that is indented by level.
Column A has level number.
I am trying to use the group command to allow easy browsing by expanding and collapsing. This is straight forward to do manually but is now a weekly update so I don't want to go through multilpe levels and thousands of rows.
Can I somehow automate grouping rows through multiple levels
Ex
1 assy 1
2 subassy 1
3 part 1
3 part 2
2 subassy 2
3 part 3
2 part 4
etc...
Attached a view of desired output.
Have you tried Excel's AutoGroup?
Originally Posted by IonImplant
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
Autooutline only works when there are formulas
Ok you got me there. What if you inserted subtotals on the first column which inserts a subtotal on each change of the level column and inserts a COUNT of the number of records in the level?
See attached file
Last edited by Excelenator; 11-02-2007 at 01:40 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks