Results 1 to 4 of 4

Thread: Power Query Result to specific location on other sheet?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2005
    Location
    York, PA
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query Result to specific location on other sheet?

    Hello all,

    I've got several query pulling out unique subsets from my main data set. This is all in the same workbook.

    When I do my PQ, I always close & load to new sheet. But, I want the result to come into the new sheet down a few rows, like maybe in cell D1 or so. This leaves me room for descriptive wording at the top of the sheet so that others can see exactly what this subset is.

    I can see how when you close & load to the same sheet, you have the option to pick cell. But not when you load to new sheet.

    Any ideas?

    Thanks,

    Mike

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,806
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query Result to specific location on other sheet?

    close&load - close&load to... connection only
    select target cell and from workbook queries right click on your table then select Load To
    Last edited by sandy666; Jun 2nd, 2019 at 07:01 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    New Member
    Join Date
    Jun 2005
    Location
    York, PA
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Result to specific location on other sheet?

    Thanks Sandy! Nice trick.

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,806
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query Result to specific location on other sheet?

    You are welcome

    Have a nice day
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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