Forum Discussion
Solved
Dynamically Generated Queries
Hi all, I have a master list with a column of staff members names. I need a query per staff member (to load to a table/sheet in excel) Currently I have manually referenced the maste...
In general you cannot have Power Query queries created on the fly, so I would say no. But I have no experience with Excel - maybe you can fudge something through Office scripts.
lbendlin
Super User
Super Userhow is that new staff member assigned to clients?
Comes from database, is just a column of staff names, with each row being a client and then their respective staff member in the column
- lbendlin
In general you cannot have Power Query queries created on the fly, so I would say no. But I have no experience with Excel - maybe you can fudge something through Office scripts.
Hi lbendlin ,
Thanks for your help, I read this was the case in an older post was hoping that might have changed. Have achieved what I needed via VBA to create new worksheets.