Hey guys,
I'm kinda new to excel and I was wondering whether it is possible to connect dropdown options to a folder hyperlink in another cell.
So for example, when you choose 'Apple' in cell A1 a hyperlink is created in D1 to the Apple folder. If you select Mango in cell A1, a link is created in cell D1 to the Mango folder,etc.
If anyone can help me, that would be greatly appreciated.
Cheers,
Pete
Hi Pete,
Lets suppose that Mango and Apple folders are stored in a folder called Fruits located in your C:\ drive. This means that the path for Mango folder is C:\Fruits\Mango.
So for doing what you asked for you have to write the following formula in D1:
=HYPERLINK("C:\Fruits\"&A1,A1)
Hope this helps!
Orlando Mezquita
Please read the Forum Rules:
If your problem is solved, mark your thread as Solved. Read Forum's rule #10 to know how to do it.
If you are happy with my answer please add it to my reputation by clicking in the icon next to the post number in my post.
"Practice isn't the thing you do once you're good. It's the thing you do that makes you good."
Malcolm Gladwell
Orlando,
Thanks heaps for your help!!
Pete.
Last edited by Rezez88; 01-05-2011 at 04:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks