[Ham-Computers] HYPERLINKING WITH EXCEL

Ed - K9EW k9ew57 at gmail.com
Mon Jul 13 22:54:37 EDT 2009


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


More information about the Ham-Computers mailing list