ups

  1. S

    UPS API Transit Time

    I need to be able to find to find a list of all zip codes within 2 day ground shipments from a single zip code. For instance, what zip codes are within 2 day UPS ground shipping time from 90210. I know UPS has the maps, but some states have multiple transit times, so it doesn't really help. I...
  2. S

    Stop or Remove File from trying to access external sources or websites

    The file in question is created by me (let's call it "File X"). It is located in my company's Shared drive - where all my files are kept. Another company (from Europe) sent us a file to fill out for them. When opened, it had a bunch of links to sites and sources that we don't have access to...
  3. W

    Relative Strength Indicator. (UDF -vba)

    Afternoon - I searched the forums and couldn't come up with anything, but I'm wondering if anyone could help modify this code that I found on another site, so that it would take into account the average of one of the functions of the previous cells. Effectively, I'm trying to modify this code...
  4. C

    Finding Approximate Matches

    <tbody> Carrier Ship Via Match or Mismatch Sunbelt No UPS, Sunbelt Only Match Fedex UPS Mismatch Fedex FedEx Account ABCD Match UPS Johnson Trucking Mismatch </tbody> I have scoured several forums including this one trying to find a solution. but have not been...
  5. B

    Count unique cells after multi-cell matching criteria against a key cell

    Hopefully I can articulate what it is I'm trying to get: I want to count how many different START UP(S) a PERSON has had specific ROLES in. In other words, where ever (A2&B2) reoccur in A:B, count how many times C2 occurs (next to the adjacent A & B cells) next to UNIQUE values in the adjacent...
  6. J

    If and vlookup formula

    I need help on constructing a look up. In my spread sheet I will plug in the service type, zone and weight in three different cells. I need it to go to a table that called rates and find the rate based on the info found in the table. example of the table below. <colgroup><col><col><col...
  7. O

    VBA Macro for UPS Live Tracking

    Hello, I am new here and quite noob tbh. I would need a VB Macro able to open UPS website for tracking a shipment number from my table ref. and get me a response with the Status appearing in the green field in UPS status. Is someone able to do it?
  8. S

    Highlight Some Duplicates but Not Others

    I'm failing at trying to come up with a statement that will only highlight the numerical values that are duplicates in a single column rather. i.e.: <colgroup><col></colgroup><tbody> 95210452 95212176 95212176 95214475 95219924 95219924 97146350 95228184 95230612 95234230...
  9. M

    Anyone has the UPS Zone calculator handy ?

    Hi , I am in need to have an excel sheet with 3 digit OriginZIPcodes( from) and 3 digit DestinationZIPCodeses(To) on Rows and columns which will give me which zone it will fall under . I can get it from UPS site . But it means each time i input the Zipcode one by one . Any help is greatly...
  10. S

    UPS / Fedex Zone Calculations

    Hi there! UPS and Fedex both have zone calculators available where I can type in my starting zip code, and the website will tell us based off of that initial zip what shipping "zone" other parts of the country are in. What I want to create is the ability to type in two random zip codes in...
  11. E

    Vlookup - tough one for sure!

    Can anyone help? I am looking to do a "lookup" whereby I find the total cost of shipping x# of boxes via UPS. Let me see if I can complicate this a bit further. When we ship a bunch of stuff to our customers, the order will go in several boxes. UPS charge different rates per box shipped. So...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top