Resuse table for multiple queries

[Memphis_JW]

I have a working query however, when I refresh the query, the results are larger than exel can hold on one sheet (over 1mill rows). So, I am trying to run the query in parts by filtering the results and working with them one at a time. 

In Excel, on sheet"fruits", in a table "apples". I already have a query that runs named "find_fruit". 

But, now (using a macro), i want to delete the data in the same table (row 3 and below leaves the headers in tact) and run a second query "find_goodfruit" in the same table "apples". 

Looking for more of a VBA solution tied that will run a query. 

[v-yangliu-msft]

Hi  @Memphis_JW ,

This is the related document, you can view this content:
Solved: reuse query steps - Microsoft Power BI Community

Solved: M Power Query: how can I reuse a function between ... - Microsoft Power BI Community

Reusing a Query and retaining applied steps - Microsoft Power BI Community

How can i re-use Power Queries? (microsoft.com)

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.