I have a number of different regional account workbooks. In each, a
worksheet with company names, addresses, etc, and account numbers.Account
numbers are in column J.

I would like to access each company on the company server without creating
individual hyperlinks for each company. Anyway to create and copy a
hyperlink to refer to the account number in the J column cells. The
hyperlink is http://www.JJJ.com/KKK/LLL/acct.asp?id= (I've spoofed the
url) where the account number would be the number listed in cell and follow
the = sign.

Any easy way to do this?

Thanks for any advice.

Regards, Bob

Try something like this

=HYPERLINK("http://www.JJJ.com/KKK/LLL/acct.asp?id="&J1)

=hyperlink("http"Bob Smith" wrote in
message ink.net...
I have a number of different regional account workbooks. In each, a
worksheet with company names, addresses, etc, and account numbers.Account
numbers are in column J.

I would like to access each company on the company server without creating
individual hyperlinks for each company. Anyway to create and copy a
hyperlink to refer to the account number in the J column cells. The
hyperlink is http://www.JJJ.com/KKK/LLL/acct.asp?id= (I've spoofed the
url) where the account number would be the number listed in cell and
follow the = sign.

Any easy way to do this?

Thanks for any advice.

Regards, Bob

Thanks for the timely reply Barb. The formula works, but now the acct number
shown in that cell shows up as a hyperlinked 0. Anyway to have it still show
the account number?

Bob


"Barb Reinhardt" wrote in message
...
Try something like this

=HYPERLINK("http://www.JJJ.com/KKK/LLL/acct.asp?id="&J1)

=hyperlink("http"Bob Smith" wrote in
message ink.net...
I have a number of different regional account workbooks. In each, a
worksheet with company names, addresses, etc, and account numbers.Account
numbers are in column J.

I would like to access each company on the company server without
creating individual hyperlinks for each company. Anyway to create and
copy a hyperlink to refer to the account number in the J column cells.
The hyperlink is http://www.JJJ.com/KKK/LLL/acct.asp?id= (I've spoofed
the url) where the account number would be the number listed in cell and
follow the = sign.

Any easy way to do this?

Thanks for any advice.

Regards, Bob

The account number shown in what cell?

This sounds like you are referencing a value in your hyperlink that has a
zero in the cell.

Tell me where you have the "hyperlink" formula and where the Account number
is displayed.

Also show the exact hyperlink formula (you can sanitize it if necessary) but
keep the cell references the same

"Bob Smith" wrote in message
...
Thanks for the timely reply Barb. The formula works, but now the acct
number shown in that cell shows up as a hyperlinked 0. Anyway to have it
still show the account number?

Bob


"Barb Reinhardt" wrote in message
...
Try something like this

=HYPERLINK("http://www.JJJ.com/KKK/LLL/acct.asp?id="&J1)

=hyperlink("http"Bob Smith" wrote in
message ink.net...
I have a number of different regional account workbooks. In each, a
worksheet with company names, addresses, etc, and account numbers.Account
numbers are in column J.

I would like to access each company on the company server without
creating individual hyperlinks for each company. Anyway to create and
copy a hyperlink to refer to the account number in the J column cells.
The hyperlink is http://www.JJJ.com/KKK/LLL/acct.asp?id= (I've spoofed
the url) where the account number would be the number listed in cell and
follow the = sign.

Any easy way to do this?

Thanks for any advice.

Regards, Bob