[Ham-Computers] HYPERLINKING WITH EXCEL

[AD5PE]

Assume column A has your callsigns.

Insert a column after A (new B).  In B2, enter
"=hyperlink("http://www.qrz.com" & B2)

Drag the formula down your log as far as you want.

When you type the callsign in its column, this cell will then be the full
text you need in your hyperlink.  

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