hyperlink to UPS tracking web site

[cbrah]

I need to enter a UPS tracking number into a cell and then create a hyperlink
that concantinates the tracking address and the cell contents. any
suggestions?

 

[Tim Williams]

No idea what the tracking URL is like but this might do the job

=HYPERLINK("http://ups.com?trackingnumber=" & A1, "Track")

Where your tracking number is in A1

 

[cbrah]

Thanks, that seems to do it. Any suggestions on how I can automate this
hyperlinking, so that I can enter (Scan in) a tracking number and have the
hyperlink automatically concantinate the web address and the number. This is
what I'm building as the correct URL:
"1za33f211346428299" - is what is seen in the cell. It is also what I have
optically scanned from the airbill.
"
http://wwwapps.ups.com/etracking/tr...iryNumber=T&InquiryNumber1=1za33f211346428299" - is the hyperlink address.

I'll have a dozen or so a day, so if I can automate the process it will help.

 

[Tim Williams]

=IF(isblank(A1),"",HYPERLINK("http://ups.com?trackingnumber=" & A1,
"Track"))

will only display a hyperlink if there is a tracking number.

How are you entering the tracking numbers? You could add some code to the
worksheet_change event to insert new links when new numbers appear.

Tim.


--
Tim Williams
Palo Alto, CA

Thanks, that seems to do it. Any suggestions on how I can automate this
hyperlinking, so that I can enter (Scan in) a tracking number and have the
hyperlink automatically concantinate the web address and the number. This is
what I'm building as the correct URL:
"1za33f211346428299" - is what is seen in the cell. It is also what I have
optically scanned from the airbill.
"

http://wwwapps.ups.com/etracking/tr...iryNumber=T&InquiryNumber1=1za33f211346428299" -
is the hyperlink address.