can I use power query to pull data from a worksheet in the same workbook?

[PeCoo]

I'm getting pretty good at pulling data from an excel file using power query to create a table (lots more to learn of course).
It is fine for pulling data from one workbook into another but is it possible to do it within the same workbook?

I have a model in one worksheet and I would like to be able to create a table from this and then use daat from that table (using SUMIFS) in a worksheet in the same workbook.
Is that possible or maybe there is a better way to do this?

 

[sandy666]

in short: yes

 

[PeCoo]

in short: yes

Thanks, but how is it done?

When I try to run a power query it shows an error as the file is already open.

 

[sandy666]

select your source table
from the ribbon - Data - From table