Shannon Adams
asked on
Hide/show detail of cell categories in Excel 2010
Please reference the attached spreadsheet. What I want to do is only show the summary of each Account# and Account Name with a total of each. If the user wants to see the detail, they should be able to click on a drop-down for each account#/name to see each line item. For example, when only showing summary, only rows 1, 2, and 7 will be displayed. Cells c2 and c7 should display "total" and cell d2 will and the sum of d3:d5 and d7 the sum of d8:d10. I appreciate any guidance to get this work in some form of what I have explained.
sample.xlsx
sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER