Hyperlink Formula to call up browser

B

Bob Smith

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
 
B

Bob Smith

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
 
B

Barb Reinhardt

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
 
Top