Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automating linking icons to different hyperlinks
I use vlookup alot for extracting info from a table of chemical data. For
each chemical i have a chemical data tabulated including a web address for safety data for each entry. On a separate sheet, I use vlookup to extract data to a summary page for selected chemicals from the master sheet. The selected chemicals change all the time. I would like to automate a link to icons on the summary page for each selected chemical so that it automatically looks to the desired safety data hyperlink (in the chemical data table) and can access the webpage for safety data when pressed. I know I can manually attach the hyperlink, but i would like to automate the task as the selected chemicals as the chemicals on the summary sheet change often and updating each link manually would be tedious. Can anyone help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automating linking icons to different hyperlinks
Hi Roger
Obviously you are used to using Vlookup. For the cell where you want the hyperlink to be, just warp your normal Vlookup inside HYPERLINK() =HYPERLINK(VLOOKUP(A1,Sheet1$A$1:$G$100,7,0)) -- Regards Roger Govier "Roger on Excel" wrote in message ... I use vlookup alot for extracting info from a table of chemical data. For each chemical i have a chemical data tabulated including a web address for safety data for each entry. On a separate sheet, I use vlookup to extract data to a summary page for selected chemicals from the master sheet. The selected chemicals change all the time. I would like to automate a link to icons on the summary page for each selected chemical so that it automatically looks to the desired safety data hyperlink (in the chemical data table) and can access the webpage for safety data when pressed. I know I can manually attach the hyperlink, but i would like to automate the task as the selected chemicals as the chemicals on the summary sheet change often and updating each link manually would be tedious. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking worksheets with hyperlinks | Excel Discussion (Misc queries) | |||
automating the linking of multiple, webpage hyperlinks to icons | Excel Discussion (Misc queries) | |||
linking script for hyperlinks for excel | Setting up and Configuration of Excel | |||
Linking hyperlinks to email | Excel Discussion (Misc queries) | |||
Linking Hyperlinks into different cells | Excel Discussion (Misc queries) |