View Single Post
 
Old 09-11-2016, 01:11 PM
darbybrown darbybrown is offline Windows 8 Office 2010 32bit
Novice
 
Join Date: Jan 2015
Posts: 4
darbybrown is on a distinguished road
Default 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?
Reply With Quote