Can PowerQuery...

[tazeo]

So I have PowerQuery cleaning some data and splitting it into different work groups. Works a treat, saves me mucho time and effort. But I am now getting greedy and want to push it further.

Can I get PQ to:

1. Split this into different workbooks instead of worksheets. That is rather than, say, 10 worksheets in a workbook, can it make 10 workbooks of one worksheet?
2. Can I also get it to create a PivotTable and PivotChart from these worksheets?

Have tried to use a VBA Macro to do it, but I can't get it to do all the steps.

Any other thoughts or ideas would be appreciated.

 

[James006]

Hi,

If you need to explode your workbook and have a separate workbook for each worksheet, a macro can easily handle this situation :

Excel Macro: Create a New Workbook for Each Sheet - ExcelBaby

Sometimes you may need to create a new workbook for each sheet, it seems very boring to do it manually, this macro can help you. Get it now!

www.excelbaby.com

 

[tazeo]

Thanks
I can get my version of the macro (though the one you have posted is much cleaner) to work, it starts going buggy for me when i try to get it to make a pivot table and chart.
I will have a go, and see if this code is a better starting point.

 

[tazeo]

Hi,

If you need to explode your workbook and have a separate workbook for each worksheet, a macro can easily handle this situation :

Excel Macro: Create a New Workbook for Each Sheet - ExcelBaby

Sometimes you may need to create a new workbook for each sheet, it seems very boring to do it manually, this macro can help you. Get it now!

www.excelbaby.com

So by the looks of it, getting the extra steps to work is beyond my skill level. errors, so many errors

Where is a good place I can put what I want for a macro and get someone to show me the right coding? Tried chatGPT, and it works, but fails me when the errors start.

 

[James006]

Hi,

Two possibilities :
1. You want to learn and fix it yourself:

Excel Pivot Chart Macros

Excel pivot chart macro to list all pivot fields currently in the pivot chart layout

www.contextures.com

2. Post your entire code in you next message, there are plenty of contributors who will fix it for you ...