[Ham-Computers] HYPERLINKING WITH EXCEL

[James B]

When I create a Hyperlink in Excel there are 2 parts to creating the hyperlink

At the top of the create hyperlink box it says "Text to Display" where
I enter the call sign - Example: n2xyz

And at the bottom is the address box where you would enter the URL -
Example: http://www.qrz.com/db/n2xyz

Click OK and then just the Call Sign is displayed in the box but it is
a link to the qrz page of that call sign.



On Mon, Jul 13, 2009 at 10:54 PM, Ed - K9EW<k9ew57 at gmail.com> wrote:
> 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