Forum Discussion
how to dynamically load data to separate sheets? TIA
this is the mock data I used for reference I have a set of monthly tasks for our department that I need to complete. After cleaning the data in a table(normally it is like 500-700 rows of data with ...
It will require a complete write-up to automate this workflow. While PQ supports many to one (like consolidation etc) but it doesn't support one to many. One query can't load into more than one sheet. You will need multiple queries. But one query also can't create multiple queries.
You will need an Excel macro do the job which will split into many sheets after you load the result.
While, it will be a very long answer to integrate with Excel do which I will do some day, but for immediate relief, use the attached macro. You just need to select the column after populating your result or any cell in that column and run the macro and it will populate the respective sheets.