+ Reply to Thread
Results 1 to 8 of 8

Getting worksheet as range in power query - dynamic

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Getting worksheet as range in power query - dynamic

    Hi Guys,

    i am using just a worksheet which i will change (add/delete/update rows) data (this is not a table which power query consuming as dynamic range).
    I would like to take all headers from header1 to header2 and use this worksheet as PQ source from range.

    How can i do this to include newly added rows?
    Add worksheet to power query somehow or create named range to get result fo worksheet?

    Screenshot_29.png

    Please help,
    Jacek
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Getting worksheet as range in power query - dynamic

    If you add/delete data to your PQ source and then click on the Refresh All Icon on the Data Tab. This will update the output automatically.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Getting worksheet as range in power query - dynamic

    Hi alansidman,

    thanks!

    My question is different. I want to connect to worksheet not in other workbook but in the same workbook - in power query you have only option to join to other workbook:

    Screenshot_31.png

    Best,
    Jacek

  4. #4
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Getting worksheet as range in power query - dynamic

    I didnt find option to get data from current workbook as worksheet - only i can take named range ora table.
    I do not want to use data in table in this case - just worksheet with columns.

    It is another way?

    Jacek

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Getting worksheet as range in power query - dynamic

    Why can't you use a named range?
    Rory

  6. #6
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Getting worksheet as range in power query - dynamic

    Hi Rory,

    thank you very much!
    I can not i am using this worksheet for other calculations.
    I mean i will use named range but it will be just named range calculated in name manager - it can be done like this!

    Jacek

  7. #7
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: Getting worksheet as range in power query - dynamic

    @Jacek;

    I don't have PQ installed but, after making a Google search I found articles describing getting data from current workbook.

    https://www.antaresanalytics.net/pos...th-power-query

    https://exceloffthegrid.com/power-qu...rent-workbook/

  8. #8
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Getting worksheet as range in power query - dynamic

    Thank you Haluk,

    yes i will use those methods!

    Jacek

+ 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. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  2. Power Query, Excel 2013/ 2016, Dynamic URL, Set parameters
    By dude6571 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-17-2019, 12:29 PM
  3. Dynamic CSV link in Power query
    By mikla90 in forum Excel General
    Replies: 9
    Last Post: 07-11-2019, 01:50 PM
  4. [SOLVED] Creating Dynamic Parameters in Excel from link to Power Query
    By Stefj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2019, 06:58 AM
  5. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  6. Dynamic Parameter Using Power Query
    By NeedForExcel in forum Excel General
    Replies: 1
    Last Post: 06-16-2016, 02:51 AM

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