zip

I have several vertical ranges of zip codes with each range equaling a specific delivery cost. If I type the a zip code in one cell, I want the cell next to it to show the price of delivery. I have been successful with different formulas, but they have only worked with one range at a time. I...

This is the age old problem where VLOOKUP pulls up #N/A, because you have duplicates of the same data in the lookup range. In my case, I have a listing of about 50K employees, and part of my form is for the users to enter the employee ID number, and have the form return all relevant information...

Hi all. I'm new to VBA. I'm trying to pull text data in aggregate into a cell in excel for each zip code query. I'm sure there are other way to put the data in columns and ways to make the spreadsheet elegant. I just want the data transferred from the site to my spreadsheet and I can go and use...

Hello, I was given a sheet to use where you can enter a zip code to generate location. The problem I have is that when I type a zip code beginning with 0 in disappears. The other problem is that the sheet is protected and the cell is locked so I can not change the format to a text. Please help...

Hi all, I have been looking at RDB ZIP code for a while now, and can get most of the code to work, except for the actual zipping of the existing files into the newly created ZIP folder. After stepping through the code - it seems to me that - the code is not recognising the ne ZIP folder. In...

Hello everyone, My name is David and I've been following the forum for a while. I've learned a lot but never got to write a post, so here I go! I'm trying to calculate the California Sales Tax that I have to remit to the state by county (aargh!), and have 3 tables: 1. Zip code and tax...

I have two sheets of data. Sheet 1 has ID's and sheet 2 has ID'sand zip codes. I need to match the zip codes to the first sheet if there is a matching ID. The two sheetsonly have some matching ID's so I can't just sort them. <colgroup><col width="64" style="width:48pt" span="2">...

Hi I'm trying to loop through all the files in a directory, including subdirectories and copy anything that has the word 'spec' in it to another location. It work fine until I come across a zip file, which has subdirectories in it. Does anyone know how I loop through files in a subdirectory of...

I have a pivot table where the Row is Zip Code and the Value is a count of zip code. In other words, it is counting how many times each zip code appears in my data set. There are 35 zip code values. Everything works perfectly for 33 of the 35 but for some reason the pivot table is treating 2 of...

Hi, I have a data set of buildings and their values. I have zip codes in one column (call it column A), and property values in the next column, (call it column B). I then have a separate list of certain zip codes - named range 'zips' in column C. I want a formula to find all of the zip codes...

I am comparing a spreadsheet vs database information. I am given a spreadsheet of addresses and I have compared the zip codes by Conditional Formatting, highlighting the duplicate values. Is there a way to only show all the data on the row of the selected area where the zip code is highlighted?

I know only enough excel to be dangerous these days, and need to sort one column of contact information into separate columns. Business, Contact Name, Title, Address1, Address2, City, State, Zip, Business Phone, Email, etc. This is what it looks like now. Text was extracted from a word...

Hi forum, I'm new here and I've been having a problem to do a 2 step search. Let me (try to) explain: I've got 2 tables I need to compare Table A (30 records) name, Street, zip, town, Value 1 Table B (50000 records) name, Street, zip, town Step 1 - Compare the following to narrow it down...

Good Afternoon, I am working with a dataset that is refreshed when a sharepoint survey is completed, and the responses to that survey are then exported to a table in Excel. I want to be able to delete an entire row(s) if the ZIP code (string) of the facility reviewed (Column Y) is the same, but...

Hi Team, i need to validation the zip code, locality name and state. currently i am keying the data and validating manually with address data base available in excel while validating i am following bellow procedure... 1st Priority is ZIP if zip code found then search for locality name and...

Hi, I have seen queries with Zip multiple files together but want to know how to zip file separately on the same folder through VBA. This is because each file carry huge data, need to compress with zip of the same file separately. Thanks.

Good Afternoon! I am trying to figure out a way/formula option to take a range data set, confirm if a value is in that range, then display a value. <tbody> Zip Start Zip End Transit Days Possible Zips 04237 04241 3 04237 04252 04258 3 04238 04239 04240 04241...

Hello, This is my first time using this forum so please be gentle. Your time and help would be greatly appreciated. I've built a list of all zip codes in the US with their corresponding organization code, of which there are ~100. A total of ~42k rows. I now need to group the data in a...

Good Afternoon, I am trying to find some code that will help me ZIP each file individually in a specific / predetermined location using WINZIP64.exe adding the same password to each zip file. I have kind of gone through circle a bit on the internet. As a bit of background; I have a macro which...

HI I am downloading data from a report a cloud based system, to Excel. Looking at the zip code in the report it has a leading zero. But when in this excel it loses the leading zero. So I made format and zip. It shows the leading zero but not really there if you look at the top the content is...