Open an existing sheet by clicking on a cell in a master sheet
I have a 'budget' sheet that lists categories like Groceries, Auto, Drugs and a few more. I would like to click on the AMT PAID cell and open a separate sheet for this category, add individual item to this list along with the expense and return the total of these expenses to the original sheet.
ie:
Category Auto
Sub Sheet Item Cost
Tires 350.00
Fuel 35.00
Oil Change 75.00
Total Exp 460.00
and then return the 460.00 to the Amt Paid cell behind Auto on the first sheet.
I know how to create the second sheet with a link but can not figure out how to return the Exp sum to the original sheet.
IS IT POSSIBLE?
|