Keeping my Hyperlinks
Hello all,
I am making a spreadsheet to visulize various componants in a Hometheater setup for price comparing I have made a list of componants and in the lists they are Hyperlinked to Pricegrabber.com, In the area I put together the system componants I want togetherI have made dropdown lists for each componant but when I select one it show just the word from the list and does not include the hyperlinks I have attatched to them, Is there a way to keep the hyperlinks of the selection I make from my list? Edward |
Keeping my Hyperlinks
Not using the dropdown.
If you used Data|Validation to create the dropdown and you're showing the link address, maybe you can use an adjacent cell with a formula: =if(a1="","",hyperlink("http://" & a1) or some variation. The user will have to click on the link in that adjacent cell, though. Dartel wrote: Hello all, I am making a spreadsheet to visulize various componants in a Hometheater setup for price comparing I have made a list of componants and in the lists they are Hyperlinked to Pricegrabber.com, In the area I put together the system componants I want togetherI have made dropdown lists for each componant but when I select one it show just the word from the list and does not include the hyperlinks I have attatched to them, Is there a way to keep the hyperlinks of the selection I make from my list? Edward -- Dave Peterson |
All times are GMT +1. The time now is 06:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com