zip

if I have a huge list of zip codes and need the one or two zeros to appear as text format, is there an easy way to add them as opposed to going down the list manually and keying: '0 or '00? thanks

Each Zip Code listed in row 1 has 4 data elements. I am trying to find the Miles for the Zip listed in row 1 and match it to the zip code 1 column over from it and give me the miles to the right of that. Essentially, I have two cells containing the 1st zip code and another containing the...

have worksheet consisting of thousands of names & address (Qrylic) have separate worksheet consisting of a few hundred specific zip codes in a single list Current =IF(QryLic!G2=VLOOKUP(QryLic!G2,Sheet1!A:B,2,TRUE),QryLic!A2:M2,"$") In perfect world: Formula (which will be used to populate a...

Im trying to get these tasks accomplished in excel but I think I am asking to much of a macro. I know some of these things are easy but others are kicking my butt. But im sure someone out there knows better then me about it. I tried to explain it as well as I could but feel free to ask any...

Hello, I created a macro in Access to run a query with a date parameter and a field that concatenates the city, state and zip fields. When the query runs and completes, I can see the concatenated field as I should and the city, state and zip are unchecked in the query to be invisible, but...

Hello, This one has stumped me for a few days now and I desperately need help. I thought simple lookup formulas would do the trick, but so far I can only get the desired result by having a ton of IFS functions (which is not efficient). What I need to do is have a formula in "C" that is looking...

In Sheet1 I have the following table of zip code formats: <tbody> ISO Country Format AU Australia 9999 AT Austria 9999 BE Belgium 9999 BR Brazil 99999[-999] CA Canada A9A 9A9 DK Denmark 9999 FI Finland 99999 FR France 99999 DE Germany 99999 HU Hungary 9999 IE Ireland A9A...

If I have a corrupted XLSX or XLSM file, can I recover by converting it to a ZIP and reading the individual worksheet XML files? Ed

I need help here. I have tried to find an answer but nothing. My problem is that I got lot of Zip Codes that connect to a spesific sales Rep. A4 3000 B4 3069 C4 Person 1 A5 3070 B5 3299 C5 Person 2 A6 3300 B6 3599 C6 Person 3 F4 is the place I put the Zip code I want to find a match for...

I am trying to use a table to determine a rate for a specific Zip code with freight class. <tbody> BK BL BM BN BO BP BQ BR BS BT </tbody> <tbody> Zip Class AMC MC 300 500 1000 2000 5000 10000 </tbody> <tbody> 08753 175 101 429.33 406.11 289.62 197.73 159.07 96.63 80.26...

Greetings - I've seen a few questions get close but return what I am looking for but not exact. I have a sheet with ranges of zip codes, columns A and B, and a transit time in C. So if a zip code is found in A, B or between then the transit time is C. A zip code not found in A, B or between it...

Sheet 1 - Summary page with County names in 10 columns Sheet 2 - All sales for out company - 3 columns - ZipCode, Total Items sold to that zip code, Dollar Value (Columns A-C) Sheet 3 - List of Each NH County and Zip Codes - 10 columns with each row containing the zip ode for that column...

Hi, I'm creating a macro that asks the user a certain folder as input and then it zips to a single file a set of other files that are in different folders (that depend on the first one). I've adapted the code that is referred in different forums (from Ron de Bruin - I don't know if I can put...

Hi all, I could definitely use your help in addressing my code. This is the first time I've ever coded in VBA so appreciate any beginner's advice and tips. As a brief background, I have an excel sheet of my county's zip codes (col 2) and their corresponding towns (col 3). I want to have a person...

Hi, Please help me in getting code of 7zip of all folders in a given range I have the code of zip but the size of zip goes beyond the limit most of the time hence looking out for 7zip of folders in a given path Please assist

Hi, This is my first time posting, so please excuse the clumsiness and poor formatting. In my job, I need to validate data before I can start anything. My biggest problem is that cities are often misspelled or entered in the short-hand way and origin/destination pair will appear twice because...

Hello, I am trying to run an Index match formula with a zip code plus class number and the formula I am using returns a value that doesnt match. =INDEX('Outbound Rates'!$CI$3:$CN$3263,MATCH($CK$13&$CM$55,INDEX('Outbound Rates'!$CF$3:$CF$3263&'Outbound...

Hi all, I could definitely use your help in addressing my code. This is the first time I've ever coded in VBA so appreciate any beginner's advice and tips. As a brief background, I have an excel sheet of my county's zip codes (col 2) and their corresponding towns (col 3). I want to have a person...

Want small help from vba experts, have data with multiple clients mapped to employee in Excel which later I am saving in . PDF file format of every client mapped on the basis of employee for I. G. Client1_emp1 Client2_emp1 Client3_emp2 Client4_emp2 Now want to zip on the basis of emp and send...

Is it possible to insert a picture from a password protected zip file into excel? I know the easy thing would be to just take the image out of the zip and insert, but this is a special case. Thanks for any help.