Results 1 to 4 of 4

Thread: Power Query Novice!

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte AawwYeahh's Avatar
    Join Date
    Nov 2019
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2016

    Power Query Novice!

    Hello all (I hope I am posting this in the correct forum)
    1. I am endeavoring to create a power query to aggregate all data from workbooks in a folder(subfolders).
    2. Folder (subfolder) contains multiple extensions (IE .jpg,.pdf etc.) I have filtered those.
    3. I want to aggregate data from single worksheet (each workbook contains 6 worksheets)
    4. All columns in worksheet are named identical.
    5. I want to compile the entries below into a single worksheet
    6. I cannot for the life of me determine how to map for single worksheet.
    7. EX: ABC Invoice .xlsx want data from only worksheet titled ledger
    8. ANY HELP WOULD BE GREATLY APPRECIATED (sorry for yelling)

    AawwYeahh
    Last edited by AliGW; 2019-11-04 at 10:44 PM. Reason: Removed plea for help - this is a help forum!

Posting Permissions

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