Power Query Result to specific location on other sheet?

[hemicbx]

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

 

[sandy666]

close&load - close&load to... connection only
select target cell and from workbook queries right click on your table then select Load To

 

[hemicbx]

Thanks Sandy! Nice trick.

 

[sandy666]

You are welcome

Have a nice day