Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FedEx tracking numbers in Excel Adam J Excel Discussion (Misc queries) 0 July 24th 06 07:34 PM
How to insert tracking numbers into my webpage for RMA tracking wiglady Excel Discussion (Misc queries) 0 April 4th 06 12:44 PM
How do I add a hyperlink to an individual word in an Excel cell? Rosalie Excel Discussion (Misc queries) 2 September 28th 05 04:09 AM
Create individual files from a row GrahamN Excel Discussion (Misc queries) 3 July 4th 05 10:01 PM
Hyperlink for a group of addresses without individual entries? Peter R Excel Discussion (Misc queries) 1 February 10th 05 02:10 AM


All times are GMT +1. The time now is 09:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"