Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic URL for first column of data from excel query?
I am using the database query to suck four columns of data from an sql
server express 2005 database and it works great. However, I would like to automatically construct a URL hyperlink for the 2nd column of data coming into the worksheet from the database query. Is there is simple one to dynamically do this? Any specific feedback would be very much appreciated. Columns: ID Boat Name Price Data: Ocean Speed 100k Sea Lion 300k Goal: <a href="www.mysite.com" + ID + Boat Name + </a. Jason |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic URL for first column of data from excel query?
Below is the example of the HyperLink worksheet function available in Excel.
The two parameters are strings a can be constructed by using the Concatenate function or using the "&" character. =HYPERLINK("http://example.microsoft.com/report/budget report.xls", "Click for report") if A1 contains "http://example.microsoft.com/report/" and A2 = "budget report.xls" and A3 = "Click for report" =Hyperlink(A1 & A2,A3) "Edgeline" wrote: I am using the database query to suck four columns of data from an sql server express 2005 database and it works great. However, I would like to automatically construct a URL hyperlink for the 2nd column of data coming into the worksheet from the database query. Is there is simple one to dynamically do this? Any specific feedback would be very much appreciated. Columns: ID Boat Name Price Data: Ocean Speed 100k Sea Lion 300k Goal: <a href="www.mysite.com" + ID + Boat Name + </a. Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scan and remove column data query | Excel Discussion (Misc queries) | |||
Dynamic web query in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I change column data based on dynamic (rolling) dates? | Excel Discussion (Misc queries) | |||
Dynamic column chart - auto sort on data range | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel |