Is there any way that when you load a PQ that you can have it out put to different worksheets (adding as needed) based upon the number of entries?
What I would like is for a list of location to be broken down into different worksheets when loaded back in (I currently use VBA to do this)
So I have 10 unique locations and when PQ is ran it would have 1 raw worksheet and 10 unique locations sheets added in (total of 11 worksheets)
Is this something that can be done via PQ?
Hi,
Usually, it's about merging data with PQ, not splitting. Having the data spead across multiple sheets creates problems when trying to create reports.
You can try loading the query as connection only, then insert a pivot table based on that connection, with Location in filter area. You will then be able to use pivot option Show report Pages, this will split data into one sheet per location. Again, bad idea, because you can simply use a slicer to filter the report instead of splitting the data.
Hi,
The PivotTable technique Catalin describes is explained in this tutorial: https://www.myonlinetraininghub.com/excel-pivot-tables-to-extract-data
Mynda
thank you for this
I'm still getting to grips with PQ and as long as I have an idea of what it can, and cant, do I should be able to do what I need it to do
