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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

Tom,

Thank you, thank you, thank you! It works seamlessly!

Marc


"Tom Ogilvy" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>
>