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

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.

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

To create a hyperlink for individual FedEx tracking numbers in Excel, you can follow these steps:

1. First, select the cell or cells that contain the tracking numbers you want to hyperlink.
2. Next, right-click on the selected cell(s) and choose "Hyperlink" from the context menu.
3. In the "Insert Hyperlink" dialog box that appears, select "Existing File or Web Page" from the list of options on the left.
4. In the "Address" field, enter the URL for the FedEx tracking page, followed by the tracking number. For example, the URL for FedEx tracking might be "https://www.fedex.com/apps/fedextrack/?action=track&trackingnumber=", so you would enter that followed by the cell reference for the tracking number. If your tracking number is in cell A2, for example, you would enter "https://www.fedex.com/apps/fedextrack/?action=track&trackingnumber="&A2.
5. Click "OK" to save the hyperlink.

Now, when you click on the cell containing the tracking number, it should take you directly to the FedEx tracking page for that package.

If you want to copy and paste this formula to other cells, you can use the "Fill Handle" to do so. Simply click and drag the small square in the bottom right corner of the cell containing the formula down or across to fill in the other cells with the same formula. The cell reference for the tracking number should update automatically for each cell.

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

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 - gsnu200793


"robinrobin" wrote:

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.

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

If you don't like the hyperlink approach, you can alwasy use VBA with the
FEDEX API.
--
Gary''s Student - gsnu200793


"robinrobin" wrote:

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.