Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a hyperlink with querystring from cell
Hi all....
I have an Excel column that contains project numbers, and I have Web reporting that reports on those projects. What I would like to do is have a column in the Excel spreadsheet that concatenates the URL to my web with the value of the project number column, i.e. A B Proj. # Report 1 12-1215 http://www.myreports.com?param=(value of cell A1) 2 12-1216 http://www.myreports.com?param=(value of cell A2) I can't seem to fall on the syntax. Any and ALL help is appreciated. Marc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a hyperlink with querystring from cell
Look at the worksheet function
=Hyperlink("http://www.myreports.com?param=(" & A1, & ")") if the parens aren't required, don't use them. It was your example. -- Regards, Tom Ogilvy "Marc Miller" wrote in message ... Hi all.... I have an Excel column that contains project numbers, and I have Web reporting that reports on those projects. What I would like to do is have a column in the Excel spreadsheet that concatenates the URL to my web with the value of the project number column, i.e. A B Proj. # Report 1 12-1215 http://www.myreports.com?param=(value of cell A1) 2 12-1216 http://www.myreports.com?param=(value of cell A2) I can't seem to fall on the syntax. Any and ALL help is appreciated. Marc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a hyperlink with querystring from cell
Tom,
Thank you, thank you, thank you! It works seamlessly! Marc "Tom Ogilvy" wrote in message ... Look at the worksheet function =Hyperlink("http://www.myreports.com?param=(" & A1, & ")") if the parens aren't required, don't use them. It was your example. -- Regards, Tom Ogilvy "Marc Miller" wrote in message ... Hi all.... I have an Excel column that contains project numbers, and I have Web reporting that reports on those projects. What I would like to do is have a column in the Excel spreadsheet that concatenates the URL to my web with the value of the project number column, i.e. A B Proj. # Report 1 12-1215 http://www.myreports.com?param=(value of cell A1) 2 12-1216 http://www.myreports.com?param=(value of cell A2) I can't seem to fall on the syntax. Any and ALL help is appreciated. Marc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create HTML code for a hyperlink from cell contents | Excel Worksheet Functions | |||
Create an hyperlink automatically in a cell | Excel Discussion (Misc queries) | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
How to create a hyperlink in excel, using the text in a cell. | Excel Worksheet Functions | |||
Can a macro create a hyperlink with unique cell information? | Excel Programming |