+ Reply to Thread
Results 1 to 2 of 2

Combining data from multiple sheets into one

  1. #1
    Registered User
    Join Date
    05-23-2015
    Location
    Redmond, WA
    MS-Off Ver
    O365
    Posts
    1

    Combining data from multiple sheets into one

    It seems to me that this should be easy, and yet, I'm stumped. I work with sales pipelines from multiple regions/countries, and each maintains their pipeline data in an Excel spreadsheet. I am trying to create a summary sheet that shows only the most relevant information (for reporting purposes) for all regions/countries. I can easily generate the summary for any one sheet using MS Query. What I'm having trouble with is this:
    • I want to combine entries from multiple countries for the same customer. For example, if there's an opp being worked for customer A in the US, and a separate opp being worked for Customer A in the UK, on the summary sheet, I want to have one row for Customer A that reflects the data from the US and the UK, rather than two separate entries.
    • I also want to display entries that may be unique to a country or region. So, for example, if the US is tracking opps for Customers A, B, C, and D, and the UK is tracking opps for Customers A, C, F, and G, I want to show Customers A and C with the US and UK opps combined, and Customers B, D, F, and G.

    Does this make sense, or is it confusing? I tried joining the data, and that just didn't work. Combinations and permutations don't look like what I'm looking for. Help!

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Combining data from multiple sheets into one

    It makes "some" sense but the actual workings of a solution and the practicality of it is difficult to tell from the description.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Combining Data from Multiple .xlsx Files with Multiple Sheets
    By jeannelee94 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2015, 10:03 AM
  2. Combining data from multiple other sheets onto one
    By kb9omaaj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2014, 01:11 PM
  3. Combining Data from multiple sheets...
    By FogCat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2006, 11:35 AM
  4. [SOLVED] Combining data from multiple sheets
    By Ron Vetter in forum Excel General
    Replies: 1
    Last Post: 04-29-2005, 03:06 PM
  5. combining data from multiple sheets
    By Allen Way via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2005, 01:06 PM

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