Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
inserting hyperlink
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
inserting hyperlink
Sure thing. Now, UPS and FedEx use different url setup, so you prb need to
use an IF statement. But here's how you could set it up. A1 & A2 will contain URL structure for UPS In A1: http://wwwapps.ups.com/WebTracking/p...uiryNumb er1= In A2: &track.x=0&track.y=0 For FedEx, in B1: http://www.fedex.com/Tracking?langua...racknumbe rs= Now, let's say you have you call out type in A4 (note that this could be done via another formula possible, since FedEx uses all numbers...) and the tracking numbers called out starting in B4. Formula in C4 would be =IF(A4="UPS",HYPERLINK($A$1&B4&$A$2,B4),HYPERLINK( $B$1&B4,B4)) Voila! -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "chuckie" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a Hyperlink | Excel Discussion (Misc queries) | |||
INSERTING CELL DATA IN A HYPERLINK | Excel Worksheet Functions | |||
How to keep cell font setting after inserting hyperlink | Excel Worksheet Functions | |||
How to keep cell font setting after inserting hyperlink | Links and Linking in Excel | |||
Hyperlink to another row broken if inserting new row between, Help | Excel Discussion (Misc queries) |