I deal with spreadsheets that I create for our customers that involve
tracking numbers from both FedEx and UPS. I'm curious if anyone knows how to
'hyperlink' the aformentioned tracking number to the appropriate website. I
deal with 100 to 1,000 at a time and right now am using a script written by a
gentleman in our IT dept. While it works, it is quite slow. I think there
might be a way to do this by using the HYPERLINK formula but I can't seem to
get it to work. I am trying to get the tracking numbers to go directly to
the section of the website that shows the progress so that the customer
doesn't have to copy/paste and submit each one. Any solutions/suggestions
are appreciated
--
chuck