Power Query vba that refreshes queries in order

[Cele]

Hi

Please see attached illustration.
Is there any vba that could run these queries in a particular order?
ConsultantCombined first then GPOS_.....afterwards?

Please advise.

Thanks in advance

Cele

 

[Chihiro]

What's the importance of refreshing in order?

 

[Cele]

the ConsultantCombined has something that the other one needs. so it needs to be run first.

 

[Chihiro]

But if everything is done within PQ's query editor. It's reference order and structure will be honored. (Even when you refresh all).

If you are loading data onto sheet from initial query and then querying that table... rethink the process and do it all within PQ.
If you need help, upload sample workbook with desensitized data.

 

[Cele]

ok thank you.