macro pivot table

  1. M

    Macro to change filter on Pivot Table and paste results in new sheet

    I am trying to create a macro for the following scenario. I have a workbook with two tabs, one with data on phone calls and the other with a pivot table of the data in the first sheet. The pivot table has two filters (Date and Type), in the rows I have a list of phone numbers and in the values...
  2. C

    Compile Error: Sub or Function not defined when recording a macro to create a Pivot Table

    Hello Everyone! I just joined this forum and would love to hear your thoughts on an issue I'm having. I have been searching online and in an Excel Macro book, but cannot figure this out. I have a feeling there is a very simple solution that I'm just missing. Software Version: Excel 2013...
  3. C

    Pivot Table Macro

    I am building a workbook for workers to use, to easily cut/paste a report into, and auto generate the work that has a due date of <!--= today, (macro to sort data, and put into new sheet). I built a pivot table macro, for them to use (work presents easier for task work), but I am not sure where...
  4. C

    VBA Macros Pivot Tables

    I am trying to take a report out of our EMR, post into Macro enabled workbook, divide the work with anything of a date needed (column heading) formula for anything with a date = today or before. I use a macro to cut that data and put into new sheet. From there I created a pivot table macro, but...
  5. H

    Pivot Table - Macro to add all fields? Help!

    Hello! I'm struggling with a Macro / Pivot problem in Excel - I'm hoping you can help! The problem I have recorded a macro that works as intended, with the exception of it automatically adding 'all column fields' to the Pivot table. I'm afraid that the columns are likely to be variable each...
  6. I

    MACRO Pivot Table 2

    Hi, I am having a problem with the code highlighted in RED and its giving me the error "Invalid procedure call or argument". Please help me on this one everyone. Also if you catch something on the code that creates an error, please let me know. Sub Sample_Pivot() Windows("Yahoo Gatekeeper...

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