View Single Post
 
Old 09-12-2016, 05:12 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit 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