I have an excel sheet that is a record of all orders my company ships to a customer, which I email to them at the end of the week. This is an ongoing sheet that's updated every day which includes all pertinent info of their orders, and in one column I list the shipment carrier ("UPS, FedEx, etc) and in the column next to it, I enter the tracking number. I'm trying to find a way to automate the tracking number column. (I'd like to avoid VBA if at all possible)
When I type in a tracking number into a cell, I would like that cell to change based on the value I am inputting.
So for example if I type this tracking number "ABC123" in cell A1, I would like that same cell to turn into this: =HYPERLINK("http://wwwapps.ups.com/etracking/tracking.cgi?TypeOfInquiryNumber=T&InquiryNumber1=ABC123")
The trick is I use 3 different shippers, so this link won't always point to UPS. So I'm wondering if I can use conditional formatting some how so whenever I type "ABC***" It will change to a link as shown above, but then if I type something like "XYZ***" it can point to a different link, like DHL for example: =HYPERLINK("https://dhli.dhl.com/dhli-client/publicTracking?searchType=HBN&searchValue=XYZ***")
Bookmarks