Results 1 to 4 of 4

Thread: Power Query Novice!

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

    Power Query Novice!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,287
    Articles
    0
    Excel Version
    Office 365 Subscription
    Which version of Excel are you using? Some earlier versions of PowerQuery are not so good on the import side, so we need to know this.

    EDIT: Your profile says 2916, so when you set up the import, PQ should give you the option to select individual tabs from your sample workbook - if all workbooks have the same structure, it will import the same things from each.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Neophyte AawwYeahh's Avatar
    Join Date
    Nov 2019
    Posts
    2
    Articles
    0
    Excel Version
    Excel 2016
    I am using Excel 2016
    Last edited by AliGW; 2019-11-04 at 11:03 PM. Reason: Please donít quote unnecessarily!

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,287
    Articles
    0
    Excel Version
    Office 365 Subscription
    I know - see the second half of my post.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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