Hi,
So im not sure if this is the place to be posting this because i dont think this will involve a vba so anyway here goes:

I have this file with account names and then I have another file with their account data in it (financials, revenues, products they bought from us, etc).

So what I need is that I keep them all on the same sheet, and all the account names are collapsed but when I click on them (or next to them whatever) that particular account collapses down and shows all the financial info about it! Like when you click a category online and see it collapses into subcategories! Only I need it done on loads of data! I tried just making separate workbooks for each account but I have like close to 200 and growing so that seems stupid!

I tried the hide and unhide function but for upper mgt thats too much excel to handle! They just need a clickable name!!

Im attaching a file with one single account name and example of its financial data - its a smaller size of what I have to put in but with excel that shouldnt matter (atleast i dont think so)!

Book1.xlsx


Any help will be appreciated!