Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2016, 01:11 PM
darbybrown darbybrown is offline Open an existing sheet by clicking on a cell in a master sheet Windows 8 Open an existing sheet by clicking on a cell in a master sheet Office 2010 32bit
Novice
Open an existing sheet by clicking on a cell in a master sheet
 
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
  #2  
Old 09-11-2016, 07:37 PM
macropod's Avatar
macropod macropod is offline Open an existing sheet by clicking on a cell in a master sheet Windows 7 64bit Open an existing sheet by clicking on a cell in a master sheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Simply insert hyperlinks to each sheet on your 'master' sheet.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-12-2016, 08:56 AM
darbybrown darbybrown is offline Open an existing sheet by clicking on a cell in a master sheet Windows 8 Open an existing sheet by clicking on a cell in a master sheet Office 2010 32bit
Novice
Open an existing sheet by clicking on a cell in a master sheet
 
Join Date: Jan 2015
Posts: 4
darbybrown is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Simply insert hyperlinks to each sheet on your 'master' sheet.
As I stated in the original post, I do have hyperlinks for each cell I want to jump, but once I enter the numbers on the hyperlink sheet I need to return the total of that list to the master.
Reply With Quote
  #4  
Old 09-12-2016, 05:12 PM
macropod's Avatar
macropod macropod is offline Open an existing sheet by clicking on a cell in a master sheet Windows 7 64bit Open an existing sheet by clicking on a cell in a master sheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

There is no reference to hyperlinks in your first post but your thread title 'Open an existing sheet by clicking on a cell in a master sheet' suggests that's what you were after.

As for having your values auto-update on your 'master' sheet, that's just a matter of using the correct formula. If those sheets have the totals in a named range or at the top of the sheet, it's just a matter of inserting a simple formula to reference the named range or the appropriate cell; otherwise, you'd need a formula that, for example, finds the last-used row and returns the value from there. Without knowing your workbook's structure, it's impossible to be more specific.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
excel 2010, programming

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Move data from one sheet to the next available row or cell of another sheet bwwalker08 Excel 0 04-10-2015 11:51 AM
Populate sheet 3 with data from sheet 1 and sheet 2 speck Excel Programming 0 01-14-2015 07:54 AM
Open an existing sheet by clicking on a cell in a master sheet Create a New Sheet from Existing Sheet with Specific Columns malam Excel Programming 1 10-17-2014 10:01 PM
Open an existing sheet by clicking on a cell in a master sheet Help Coloring a cell in Sheet one if data is missing from another sheet Aeducan Excel 1 06-22-2014 04:49 PM
copy cell from sheet 2 to sheet 3 macro slipperyjim Excel Programming 1 02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft