I'm looking into creating a drill down budget but I can't find the info I'm looking for. I want to be able to double-click an item on the first sheet and have it take me to another sheet to see the full break down of the item.
(i.e. click on the crew tab on the first sheet and have it take me to the second sheet detailing how much positions are getting paid in the budget. Then look at the first sheet to see a total sum to make it match the budget.)
I've done this before with a specific budgeting software for a movie but I want to be able to create my own so I can customize it more based on the company.