macro - pivot table

  1. tazeo

    Need help with copying worksheets and creating pivot tables/charts in new workbooks using Macro

    I've been working on a report that I clean and collate using PowerQuery, and it's been fantastic. However, I'm facing a slight issue when it comes to taking the output (which has been split into worksheets, with one worksheet for each work group) and creating a new workbook for each sheet. My...
    • tazeo
    • Thread
    • excel help - macros macro - copy/paste macro - pivot table
    • Replies: 0
    • Forum: Excel Questions
  2. E

    Macro that creates a Pivot Table - Error

    Hello, I'm a strong excel user with no coding skills. I have recorded a Macro that takes raw data and creates a table then creates a Pivot Table. I am getting an error that I can't explain. Run-time error '1004': Application-defined or object-defined error When I select "Debug" it highlights...
  3. M

    Macro to update Pivot Source Folder

    Hi, I am looking for a macro to update the data source automatically. This will also mean that the table range will increase with additional rows, sometime additional columns. Each month we receive 2 source data files which I save to our server for the given month. Both data files are saved...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top