View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marc Miller Marc Miller is offline
external usenet poster
 
Posts: 3
Default 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