I have some code that does its job in adding datafields to a pivot table. I linked it with a form control button:
' PDA1P Macro
' Adds all 1P PDA columns into values of PT
' Keyboard Shortcut: Ctrl+Shift+P
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...
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?
' Testvba Macro
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 ??
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.
' Macro2 Macro