Start a new topic
Add Reply
Hey yall,
Got a quick question about Excel and the hyperlink function.
Sheet 1 = full of random data
Sheet 2 = summary, from which I include the function hyperlink to take me to the details in Sheet 1.
My question is, could I link Sheet 2 summary to a particular line in Sheet 1 details, say A75!Sheet1! ?
Also, if anyone can help me remember a function, can't remember what it's called but when I double click the cell, it pops up a sheet with the details of that cell value.
Kinda shocked at how easily it is to forget code/functions. Algorithms and logic functions are engrained in my memory, but everything else just slips like... like slippery stuff.
Thanks
MSExcel
Page 1 of 1
MSExcel
Hyperlink
Rate Topic:
MultiQuote
#2
bsaunders
- D.I.C Addict
-
Reputation: 43
- Posts: 571
- Joined: 18-January 09
Dream Kudos: 0
Re: MSExcel
Posted 08 February 2009 - 04:11 PM
Honestly, I don't use Excel, but from browsing links returned from Google, I put together this formula which I think should work:
=HYPERLINK("[sheets.xls] Sheet1!A75", "View Summary")
This is where I got the tutorial from:
HYPERLINK - Excel - Microsoft Office Online
As for the double-clicky cell poppy-uppy thingy, I have no clue.
=HYPERLINK("[sheets.xls] Sheet1!A75", "View Summary")
This is where I got the tutorial from:
HYPERLINK - Excel - Microsoft Office Online
As for the double-clicky cell poppy-uppy thingy, I have no clue.
Was This Post Helpful?
0
Page 1 of 1
| 
