Automating hyperlinks
Is it possible for excel to generate a hyperlink to a sub-folder based on a cell content.
I have a spreadsheet that lists a unique reference code in A2. In D2 is a cell with a hyperlink to a sub folder. Each unique reference has a sub folder set up. Can I automatically make the hyperlink point to the correct sub-folder without having to manually do each one?
If it is possible - could someone point me in the right direction as to how to go about this?
I look forward to hearing from you
Last edited by xsiguy69; 02-11-2013 at 12:07 PM. Reason: Error in Title
You should be able to use the HYPERLINK() formula instead of hardcoded CTRL-K hyperlinks. The formula would let your piece together the URL from text strings.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon 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!)
Thanks for the quick response. What would the text string look like? In my mind it would look like HYPERLINK('/Evidence/'(A2)) - is this right?
Path & Filename
Formula:
Please Login or Register to view this content.
Or Using complete file path with file name and extension
Formula:Please Login or Register to view this content.
Or Using path with file name mentioned in A1 cell
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks