zip

In my worksheet I'm trying to fill in the Zip Code column based on the City and State listed for each row. I downloaded a zip code database and added it to my worksheets a new tab in the hopes that I'd be able to use the VLOOKUP formula to populate the field from it, but I can't seem to figure...

I have a list of employees, and a list of offices. I want to find which office location an employee is closest to, based on the employee's home zip code - so, find the closest zip code in the office list, to each employee's home zip code: <colgroup><col><col><col...

Hi folks, Below is a visual of my problem. I have zips all listed in one row / several columns B:F (all zips are unique), I would like to have zip in Column J lookup the value in Column A, if it finds a zip that are in columns B:F. Do you have any suggestion? or maybe how I can simply...

<rate<font color="#000000"><rate name="SEATTLE" code="1726" staterate="0.065" localrate="0.036">I have a working spreadsheet which uses a vba to query a web service and return a tax value and other information. However, recently I found a bug that stems from excel having not created the schema...

I am currently trying to look up 1 value - which is a state and could have up to 3 matches with that state, where there are up to 3 different zip codes that I would like to return in order to do other formulas based on the 1-3 results. I would like to reference the look value on 1 tab and have...

I have a routine that creates a new copy of a worksheet and then the user inputs data through drop down boxes. In zip code, I have the cell with data validation linked to a named list of zip codes. However, one can enter anything in the dialog box and it will input it into the zip code cell...

I have a routine that creates a new copy of a worksheet and then the user inputs data through drop down boxes. In zip code, I have the cell with data validation linked to a named list of zip codes. However, one can enter anything in the dialog box and it will input it into the zip code cell...

I have never really used match and index before and I believe these will be needed to solve my problem I price list in one sheet and an invoice in another In the invoice I get in info in 4 columns that I use to check against my price list - Country, zip code, weight and then price The price...

If I want to select a group of people in a state and do reports by city and list them by first and last names with their address, and zip code, is pivot table the way to go or should I just sort them by city and then make separate worksheets by city?

Hi, I'm looking for a code to zip the folders of a path specified in my cells(1,1).value After searching i found vba codes to zip the files of a folder but they are using WinZip. My office machine does not have a WinZip installed and we are restricted to use WinZip. Could anyone please help...

Can a hyperlink on a spread sheet be constructed to lookup last four digits of a US zip code entered in another cell?

My goal is to get file sizes for XML files located in a ZIP folder. I have changed an Excel file’s extension to “.ZIP” and I am trying to only extract the .XML file names. FYI, this may only work on new versions of Windows and Excel. I am using Shell.Application to extract the file names. My...

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...

Hi Everybody, In combination with rules & alerts I manage to automatically save a certain ZIP file (containing 1 file) to a directory specified below. However, to be able to work with this file in a macro it has to be automatically extracted in this directory as well. Doing this extract, the...

Can someone help me with the vba code to extract only excel files from multiple zip files from a folder..

I'm very new to VBA and programming and so I have no real idea how I can get around this problem that I have. Any help would be greatly appreciated! Sorry if it's difficult to understand exactly what I'm trying to do. If you need clarification on anything I will be online to answer any questions...

Hi all This is really a DOS/Command Line/Shell question but it's being run out of VBA and I know this forum better than any other. I need to add a file to a zip file. I have working code that does this using SHELL() the below: "C:\Program Files\Winzip\winzip32" -min -a...

Hi people! I want to know if its possible for Excel to recognize city/state names for US zip codes. The idea being that I have a column of zip codes and want to know if there is a formula/ way of having the column next to it automatically name the city/ state for me? Another question: Anyone...

Hi, I am trying to use the code provided here: http://www.rondebruin.nl/windowsxpzip.htm to get excel to zip some files for me. I included the first bits and am trying to use the sub that zips an entire folder that I specify. It keeps giving me Run-time error though. It says: Run-time error...

Hi, I'm using a module in excel that sends an email. The module selects a named range, creates a temporary excel file, pastes in the named range and then sends the temporary file in email. I need the module to zip the temporary file and add a password before emailing the file. This is...