hello, how to hyperlink a cell in sheet1 to cell in sheet2 that contains 12343321
thank you for helping.
hello, how to hyperlink a cell in sheet1 to cell in sheet2 that contains 12343321
thank you for helping.
3D HYPERLINK Formula
Example #2 is what you want.
Last edited by JBeaucaire; 12-27-2019 at 04:26 AM.
_________________
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!)
jbeaucaire thank you for your fast response, pls describe clearly the formula,
i have sheet1 and sheet2
i need to hyperlink cell A5 in sheet1 to dropme to cell in colum A in sheet2 that cell contains 123456
Edit the MATCH() part of the formula....
MATCH(ValueToMatch, RangeToSearch, 0)
ValueToMatch
If you cannot get it to work, show me what you've tried.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks