Notifications
Clear all
Power Query
4
Posts
2
Users
0
Reactions
79
Views
Topic starter
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 
Posted : 19/01/2018 11:35 am
Hi Celeste,
The code for refreshing a query is simple:
Sheets("Sheet 1 Name").ListObjects("Table1 Name").QueryTable.Refresh BackgroundQuery:=False
Sheets("Sheet 2 Name").ListObjects("Table2 Name").QueryTable.Refresh BackgroundQuery:=False
Posted : 20/01/2018 4:43 am
Topic starter
Catalin, it worked. You are the BEST!! 
A billion thanks!!!!!!!!
Celeste
Posted : 20/01/2018 11:41 am
Glad to hear you're happy with the solution 🙂
Posted : 20/01/2018 2:00 pm
