Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automating the linking of multiple, webpage hyperlinks to icons
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 | |||
excel - hyperlinks to pdf documents and saving as webpage | Excel Discussion (Misc queries) | |||
Semi-automating the generation of multiple cell range names | Excel Discussion (Misc queries) | |||
Linking Webpage to Excel Data | Excel Worksheet Functions | |||
Linking Hyperlinks into different cells | Excel Discussion (Misc queries) | |||
How do I avoid multiple icons of Excel when using short command Al | Excel Discussion (Misc queries) |