Make your knowledge visually interesting and easy to comprehend Say you want to show your enterprise market proportion or figure out what merchandise are selling the most. Instead of showing a possible random series of numbers and categories turn your knowledge into a Zone chart fedex ground that gives you important promoting at a glance.
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 excel, and have there be a calculation done through to tell me what zone the shipment would be considered. Everything is based on the first 3 digits of a the Origin zip code and the first 3 digits of the destination zip codeA link to the spreadsheet can be found atOn the spreadsheet, I have added what two of the 708 different possible zone charts would be (tab 9) and samples of what we would want the final calculations to look like (tab zone calc)Obviously, i realize that 708 charts at 211 (+/-) lines each chart, is A LOT of data. What would be the best way to go about doing this? At this point it is something we are looking to do ONLY for ground shipping, but in theory, would be wanting to do for express as well (possibly have each service on a different tab???). First I would ask why the only options for Origin Zip are 9 and 9?But anyway if what you want to do is find the ZONE that matches the first three digits in the Origin Zip AND the first three digits in the Destination Zip, it's going to be a bit of a process.
First, the table has some destination zips like '###' and some like '###-###' - so you'd have to have a little IF function to say if column B is '###' then look it up that way, but if it's '###-###' then look up in between those two numbers. That's kind of confusing and is going to make for a formula I really don't want to try to put together. It might be easier to make a new table where you just include all zip codes. Maybe go to and download their zip code database.
So copy all the zip codes to a new table. Index/match to find the zones for 9 and the same for 9100-91899. THEN you can do an easy INDEX/MATCH/IF to find which ZONE matches both the Origin Zip and Destination Zip.
First I would ask why the only options for Origin Zip are 9 and 9?But anyway if what you want to do is find the ZONE that matches the first three digits in the Origin Zip AND the first three digits in the Destination Zip, it's going to be a bit of a process. First, the table has some destination zips like '###' and some like '###-###' - so you'd have to have a little IF function to say if column B is '###' then look it up that way, but if it's '###-###' then look up in between those two numbers. That's kind of confusing and is going to make for a formula I really don't want to try to put together.
It might be easier to make a new table where you just include all zip codes. Maybe go to and download their zip code database.
So copy all the zip codes to a new table. Index/match to find the zones for 9 and the same for 9100-91899. THEN you can do an easy INDEX/MATCH/IF to find which ZONE matches both the Origin Zip and Destination Zip. Hi Snuffin-did you ever find a solution to this? I actually have the tables for Fedex , I just cannot get the master tables for UPS.Steveyes, currently have a zone calculation, and rate calculation tool up and running for UPS.
It has been working great so far. I even updated to accomodate the 2016 rates and all worked perfectly with that.The one problem is that there is just SO MUCH information to create this tool, that it gets bogged down sometimes. Just data alone is about 4mb.
Not taking into consideration the calculations. PM me, maybe I can help you out with what you are working on?? (19 responses) Trying to do something like this If 'Yards' is in column A then copy and paste all the rows to a new book If 'Grass' is in Column A the.(9 responses) I have a user from that is the first part of a mass email script that I am trying to write. What I would like is select one or several checkb.(7 responses) I want to enter information on to the first worksheet, then the code to copy and paste the data to the selected hospital and ward entered in.(24 responses) I have figured out some code to copy all the data from a table, create a new workbook, paste the data and then save the workbook as a CSV as.(10 responses) I have a series of columns for orders on my spreadsheet. The furthest left column contains item numbers, the second column contains the quan.The Holy Grail of Excel Tips $12.60.
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 excel, and have there be a calculation done through to tell me what zone the shipment would be considered. Everything is based on the first 3 digits of a the Origin zip code and the first 3 digits of the destination zip codeA link to the spreadsheet can be found atOn the spreadsheet, I have added what two of the 708 different possible zone charts would be (tab 9) and samples of what we would want the final calculations to look like (tab zone calc)Obviously, i realize that 708 charts at 211 (+/-) lines each chart, is A LOT of data. What would be the best way to go about doing this? At this point it is something we are looking to do ONLY for ground shipping, but in theory, would be wanting to do for express as well (possibly have each service on a different tab???). First I would ask why the only options for Origin Zip are 9 and 9?But anyway if what you want to do is find the ZONE that matches the first three digits in the Origin Zip AND the first three digits in the Destination Zip, it's going to be a bit of a process.
First, the table has some destination zips like '###' and some like '###-###' - so you'd have to have a little IF function to say if column B is '###' then look it up that way, but if it's '###-###' then look up in between those two numbers. That's kind of confusing and is going to make for a formula I really don't want to try to put together. It might be easier to make a new table where you just include all zip codes. Maybe go to and download their zip code database. So copy all the zip codes to a new table. Index/match to find the zones for 9 and the same for 9100-91899. THEN you can do an easy INDEX/MATCH/IF to find which ZONE matches both the Origin Zip and Destination Zip.
First I would ask why the only options for Origin Zip are 9 and 9?But anyway if what you want to do is find the ZONE that matches the first three digits in the Origin Zip AND the first three digits in the Destination Zip, it's going to be a bit of a process. First, the table has some destination zips like '###' and some like '###-###' - so you'd have to have a little IF function to say if column B is '###' then look it up that way, but if it's '###-###' then look up in between those two numbers. That's kind of confusing and is going to make for a formula I really don't want to try to put together.
It might be easier to make a new table where you just include all zip codes. Maybe go to and download their zip code database.
So copy all the zip codes to a new table. Index/match to find the zones for 9 and the same for 9100-91899. THEN you can do an easy INDEX/MATCH/IF to find which ZONE matches both the Origin Zip and Destination Zip. Hi Snuffin-did you ever find a solution to this? I actually have the tables for Fedex , I just cannot get the master tables for UPS.Steveyes, currently have a zone calculation, and rate calculation tool up and running for UPS. It has been working great so far.
I even updated to accomodate the 2016 rates and all worked perfectly with that.The one problem is that there is just SO MUCH information to create this tool, that it gets bogged down sometimes. Just data alone is about 4mb. Not taking into consideration the calculations. PM me, maybe I can help you out with what you are working on?? (19 responses) Trying to do something like this If 'Yards' is in column A then copy and paste all the rows to a new book If 'Grass' is in Column A the.(9 responses) I have a user from that is the first part of a mass email script that I am trying to write. What I would like is select one or several checkb.(7 responses) I want to enter information on to the first worksheet, then the code to copy and paste the data to the selected hospital and ward entered in.(24 responses) I have figured out some code to copy all the data from a table, create a new workbook, paste the data and then save the workbook as a CSV as.(10 responses) I have a series of columns for orders on my spreadsheet.
The furthest left column contains item numbers, the second column contains the quan.The Holy Grail of Excel Tips $12.60.