+ Reply to Thread
Results 1 to 2 of 2

Combine data from multiple sheets into one

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2007
    Posts
    1

    Combine data from multiple sheets into one

    Hello! (This is my first post on any sort of forum)

    I'm working in a large database that has the same formatting on each sheet. I use the database to track vehicle orders from start to finish. When an order is placed it goes on one sheet, then as the order progresses I move it to the next sheet, and so on...) My sheets are: New Orders, Approved, On the Road, Returned.

    What I am looking to do is have a master sheet of Customer names with out duplicates so that I can track how many orders that specific customer has had (Plus some other things involving a pivot table but we will get to that another time once I figure this out.)

    To Clarify: I want to be able to list how many unique customer names I have in the entire database. Customer Steve could have 2 orders in Approved and 3 on Returned. But I only one his name to appear once on the master sheet of Customer names.

    I have been trying to run a Macro that pulls ALL data from ALL my sheets, dumps it into the Master sheet, then removes duplicates, but have yet to be successful with that.

    Any ideas on what the best way is to get the data I am looking for?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Combine data from multiple sheets into one

    Hi and welcome to the forum

    1st of all, it would be hard to offer any meaningful suggestions without being aboe to see what you are working with.

    2nd (and Im sure you dont want to hear this) it may be easier to work with your data if it was ALL in 1 sheet to begin with, and then you ran your queries and extracts on another sheet/s

    It might be easier if you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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