+ Reply to Thread
Results 1 to 3 of 3

Create Singular record from a Zip Code Range table

  1. #1
    Registered User
    Join Date
    06-23-2020
    Location
    Long Island, New York
    MS-Off Ver
    365
    Posts
    2

    Question Create Singular record from a Zip Code Range table

    I have a zip code table that is used to assign sales hierarchies in my CRM. The table is set up with a range of zip codes / record rather than a singular zip code.

    Capture Columns.JPG

    I need to recreate this file to be one record for each zip code for use outside our CRM.

    so the above would look like this

    After.JPG

    I had another sign on here which I had trouble getting in to, it's been years, but someone here had taken the file placed in the formulas and sent back the solution. Somehow the original file got corrupted by someone, and now I have lost the solution.

    Note: I need to return all the fields above with the correct zip codes..

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    372

    Re: Create Singular record from a Zip Code Range table

    Hi zoso333,
    I am not familiar with all the zip codes in the USA, but there must be a site to download all of them with the information you need.
    try: https://www.unitedstateszipcodes.org/zip-code-database/ there is a free database download for personal/non-commercial use.
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

  3. #3
    Registered User
    Join Date
    06-23-2020
    Location
    Long Island, New York
    MS-Off Ver
    365
    Posts
    2

    Re: Create Singular record from a Zip Code Range table

    There is only lists of used zip codes without unused numbers which is not useful but it is also not what I need.

    I need the 2nd image. A table with each individual zip code with the region area and community information.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] code to record an amount into a table
    By chubbychub in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-19-2018, 12:19 PM
  2. How to Create Singular/Plural Formats in FORMAT CELL option?
    By e4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2017, 02:02 AM
  3. Replies: 0
    Last Post: 01-19-2015, 11:00 AM
  4. [SOLVED] Change Pivot Table Data Source to range A7: last record in F column
    By johnstevens in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-09-2014, 08:35 AM
  5. Replies: 0
    Last Post: 11-27-2013, 10:37 AM
  6. [SOLVED] Record a Macro to create a Pivot Table (Different Sizes)
    By 00pumpkin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2013, 08:48 AM
  7. Replies: 1
    Last Post: 01-17-2012, 10:47 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1