[Ham-Computers] HYPERLINKING WITH EXCEL

[AD5PE]

One correction - I forgot the slash:

=hyperlink("http://www.qrz.com/" &  B2)

You need the slash after .com to have a valid URL.

Jay

-----Original Message-----
From: ham-computers-bounces at mailman.qth.net
[mailto:ham-computers-bounces at mailman.qth.net] On Behalf Of Ed - K9EW
Sent: Monday, July 13, 2009 21:55
To: Computers (or other) used for amateur radio, communications,or
experimenting
Subject: Re: [Ham-Computers] HYPERLINKING WITH EXCEL

Hi James,

The "calletters" is the part I don't know how to do automatically.  I
created a hyperlink in the cell that contains the calletters of the station
worked, but I want to click on that cell, and have it go to
http://www.qrz.com/calleters, where calletters is the text in the cell.  How
do I do that with a click of the mouse?

-ed

On Mon, Jul 13, 2009 at 8:58 PM, James B<24.driver at gmail.com> wrote:
> Yes, enter the hyperlink URL as
>
> http://www.qrz.com/db/callletters
>
> Where callletters is the call sign of the station worked
>
>
> On Mon, Jul 13, 2009 at 6:46 PM, Ed - K9EW<k9ew57 at gmail.com> wrote:
>> Hi to the group.  I'm part way to a solution, but need some help.
>>
>> I have an Excel spreadsheet that I use for logging.  In one of the 
>> cells I enter the callsign of the station worked.  Once the 
>> information is entered, I would like to click on that cell, and have 
>> Excel take me to the QRZ.com page with the information about that 
>> operator.
>>
>> I can get as far as clicking on the callsign cell and winding up on 
>> QRZ, but once I'm there, I have to enter the callsign manually (like 
>> you would normally use QRZ).
>>
>> Does anyone know how to make that last step automatic?
>>
>> tnx es 73,
>> ed - k9ew
>> ______________________________________________________________
>> Ham-Computers mailing list
>> Home: http://mailman.qth.net/mailman/listinfo/ham-computers
>> Help: http://mailman.qth.net/mmfaq.htm
>> Post: mailto:Ham-Computers at mailman.qth.net
>>
>> This list hosted by: http://www.qsl.net Please help support this 
>> email list: http://www.qsl.net/donate.html
>>
> ______________________________________________________________
> Ham-Computers mailing list
> Home: http://mailman.qth.net/mailman/listinfo/ham-computers
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:Ham-Computers at mailman.qth.net
>
> This list hosted by: http://www.qsl.net Please help support this email 
> list: http://www.qsl.net/donate.html
______________________________________________________________
Ham-Computers mailing list
Home: http://mailman.qth.net/mailman/listinfo/ham-computers
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:Ham-Computers at mailman.qth.net

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html No virus
found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.387 / Virus Database: 270.12.92/2203 - Release Date: 07/13/09
05:56:00