+ Reply to Thread
Results 1 to 2 of 2

Pulling out certain Zip Codes in Sales Report

  1. #1
    Registered User
    Join Date
    04-03-2008
    Posts
    1

    Pulling out certain Zip Codes in Sales Report

    Hello - I'm new to this forum and I'm hoping to find some help. I know some Excel basics but nothing too detailed for what I need to do. We have a quarterly sales report in my office that is broken up by zip codes in one of the columns and what I need to do is based on the zip code determine which sales rep that line belongs to.

    I have a list of which zip codes belong to each sales rep - but is there a way I can enter in one reps list of zip codes to automatically search the workbook and filter all the matches to a new sheet? This report is large and it takes up quite a bit of time to do this manually so I was really hoping there was an easier way to do this.

    Thank you so much in advance for any help you can provide.

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    846
    Hi and welcome to the forum.

    Sounds like your problem could be solved using a pivot table.


    http://www.cpearson.com/excel/pivots.htm
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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