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

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

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