Hi guys,
I have some code that does its job in adding datafields to a pivot table. I linked it with a form control button:
Sub PDA1P()
'
' PDA1P Macro
' Adds all 1P PDA columns into values of PT
'
' Keyboard Shortcut: Ctrl+Shift+P
'
ActiveSheet.PivotTables("SpendTable").AddDataField...
Is it possible to create a Macro that will sort some data, then used this sorted Data to create a Pivot table, then using the results of the pivot table, pasting the results as values then creating another pivot table? All this is done on the same sheet.
I have tried to create this macro and...
Hi
I've recorded the following Macro in a workbook called SCSGroupageT which is obviously referenced in the code. How do i need to amend the code so that it will run in any workbook?
Thanks
Sub Testvba()
'
' Testvba Macro
'
'
Range("A1:I2656").Select
Range("C4").Activate...
Hello
I have made a pivot table with the code below but when i add a new date "rows" the new data didn't appear in the pivot table
how to Fix it ??
Range("A5:S1000").Select
ActiveWorkbook.Worksheets("PIVOT1").PivotTables("PivotTable2").PivotCache. _
CreatePivotTable...
Hi,
I am trying to Run the dynamic selection Pivot tab,its reflecting a error as Invalid procedure call or argument I have bolded the code lines which reflect error .I am unable to figure out what went wrong.
Sub Macro2()
'
' Macro2 Macro
'
'
Range("N3").Select...
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.