How do I create a hyperlink for individual FedEx tracking numbers.

[robinrobin]

I am creating lists that contain current in transit FedEx tracking numbers.
I would like to format the column in Excel that would let each tracking
number link to FedEx and go the the tracking information that is specific to
the package. I have seen this done and have received these back to me but
the formula that is showing I can not copy and paste and keep the tracking
information locked to the current cell. It just brings the old tracking
number forward.

 

[Gary''s Student]

You need to cheat and do one manually. Say you go to a site and want data on
record 31415926. You perform the entry and the web site displays the data.
You also save the URL. Say it is:

http://www.qwerty.com/hvkhvhvfdhvd31415926

In column A in A1 enter:

31415926 and in B1 enter:

=HYPERLINK("http://www.qwerty.com/hvkhvhvfdhvd" & A1,A1) and copy down

 

[Gary''s Student]

If you don't like the hyperlink approach, you can alwasy use VBA with the
FEDEX API.