HTML Link for UPS tracking number

Hi, I need to create an excel spreadsheet that has clickable UPS tracking numbers. I have the tracking numbers, but need an HTML link template so people can click a link to see shipment status. Thanks in advance for any direction.
Mark BDirector ITAsked:
Who is Participating?
 
Ken SelviaConnect With a Mentor RetiredCommented:
Not a SQL question, but you can create this formula in an Excel cell row 1;

=HYPERLINK("http://ups.com?trackingnumber=" & A1, "Track")
 
assuming A1 contains your tracking link. Copy down the formula to all of your other rows.
0
 
nishant joshiTechnology Development ConsultantCommented:
might it an small project not a question.if you want to create just html page then go to word and inserts data and save your page as html.

Regards,
nishant
0
 
Jeffrey CoachmanMIS LiasonCommented:
AFAIK, the UPS tracking number is click-able....

Try right clicking the Tracking number (link), and pasting the link location into Excel...
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Mark BDirector ITAuthor Commented:
kselvia- that is what I am looking for. Your weblink did not seem to pass the trackingnumber url parameter to auto bring up the shipment information, but this seems to work: =HYPERLINK("http://wwwapps.ups.com/WebTracking/track?HTMLVersion=5.0&loc=en_US&Requester=UPSHome&WBPM_lid=homepage%2Fct1.html_pnl_trk&trackNums="&B2&"&track.x=Tracka", "Track")
0
 
Ken SelviaRetiredCommented:
glad to hear it. my example was just something I found when I googled for it. It was probably using an old URL.
0
 
Mark BDirector ITAuthor Commented:
Was looking for working UPS URL, but this pointed me in right direction and concept was what I was looking for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.