Let's say column C is where I am listing our all my components/parts and column H is where I have that component's final cost. One row being one component. For any components that are manufactured by us I then insert a row for each manufacturing process. Some components have 2 processes some have 10 etc. I want to be able to toggle between top level aka component name and final cost then be able to toggle to see all the detail. My initial thought was to add a row between each row and create groupings. Then by clicking 1 I would get to the top level I am after - component and final cost or by clicking 2 I could see all the detail. The problem with that is by clicking 2 It expands all the empty rows I have. My goal is to find a way, assuming by using VBA, to expand/collapse only the rows that have data in them. Hope this makes sense and thank you in advance!