Hello all,
In the attached file, rather than just directing me to the single cell when I click on the hyperlink, I want it to highlight the entire row. Does anyone know how to do this?
Thanks!
Hello all,
In the attached file, rather than just directing me to the single cell when I click on the hyperlink, I want it to highlight the entire row. Does anyone know how to do this?
Thanks!
Name a range and in the Hyperlink click in "Places in this document > Named Ranges > "Your range name"" as I did in the workbook example
"The quieter you become, the more you are able to hear"
Any reputation (*) points appreciated.
"If you know yourself but not the enemy, for every victory gained, you will suffer defeat."
Sorry, I should have mentioned, I can't use that method because I have many columns and rows of data and they're often moving around. So if I did it that ways I would have to update the hyperlink each time and that just wouldn't be feasible.
Maybe if you use a pivot table showing the Hotel Code? and double click the result that brings you to the "source" data?
Ya, that's an option that I'm very fond of. I'm just afraid that would be too complicated for my directors though......................................
Oh...Need to think then...Can't think in any easy solutions for now ... You could tell them how to do that :PP
Like so:
=HYPERLINK("#'Calc Page'!A" & MATCH($A6, 'Calc Page'!$A:$A, 0) & ":G" & MATCH($A6, 'Calc Page'!$A:$A, 0), B6)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks