+ Reply to Thread
Results 1 to 2 of 2

Help with power query, trying to combine worksheets in separate books.

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,184

    Help with power query, trying to combine worksheets in separate books.

    Have 8 separate workbooks that have sheets titled "DCMR." that I need to pull and merge. Row 1 is a header. The workbook has other sheets. When I try to talk through to add it, I can't figure out how to only select the sheet I want.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    11,857

    Cool Re: Help with power query, trying to combine worksheets in separate books.

    Here is example
    unzip it into C:\ directly because of path inside
    Attached Files Attached Files
    sandy
    Learn Power Query (XL2010/2013 require PQ add-in)
    I want to see what you are trying to achieve, not how you are trying to do it
    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ 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] Power Query: Group by category, list text items on separate rows
    By JimDandy in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-05-2017, 12:11 AM
  2. Replies: 1
    Last Post: 06-06-2017, 11:38 AM
  3. Combine 3 separate workbooks, each with 6 worksheets
    By billycasper in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2014, 07:16 AM
  4. Combine multiple files in one, under separate worksheets
    By plans in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2014, 04:04 AM
  5. [SOLVED] Excel Power Programming, Bible books
    By Jeff in forum Excel General
    Replies: 3
    Last Post: 12-07-2005, 03:45 PM
  6. [SOLVED] Excel Power Programming, Bible books
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2005, 03:45 PM
  7. [SOLVED] Combine Workbooks as separate worksheets
    By SAL in forum Excel General
    Replies: 2
    Last Post: 06-01-2005, 12:05 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