kaichowyang
04-30-2013, 06:57 PM
Hi Everyone!
I've been a lurker for sometime and I tried my best to look for the solution in the search and archives but I can seem to find anything.
I was wondering if there was a way to create a macro to insert hyperlinks onto cells with truncated url's (Meaning the rootdomains have been removed. For ex. instead of www.happy.co m/elephants/ it's just /elephants/.)
http://i.imgur.com/SdNQgX6.png
I would like to be able to click the contents and have them link me to the website itself (click /elephants/ and it would take me to [url]www.happy.com/elephants/. I would like to source the hyperlinks from a list of url in another sheet.
http://i.imgur.com/NNN5JY4.png
Is there a way to do this or am I insane ?
Thanks Everyone!
I've been a lurker for sometime and I tried my best to look for the solution in the search and archives but I can seem to find anything.
I was wondering if there was a way to create a macro to insert hyperlinks onto cells with truncated url's (Meaning the rootdomains have been removed. For ex. instead of www.happy.co m/elephants/ it's just /elephants/.)
http://i.imgur.com/SdNQgX6.png
I would like to be able to click the contents and have them link me to the website itself (click /elephants/ and it would take me to [url]www.happy.com/elephants/. I would like to source the hyperlinks from a list of url in another sheet.
http://i.imgur.com/NNN5JY4.png
Is there a way to do this or am I insane ?
Thanks Everyone!