hi,
I wanted to create pivot table with vba .
I am not good in VBA, so please anyone can help me to create a vba code for me.
I also try to find code from other sites, but didn’t get any output.
here, I am attaching the data file and also the pivot output so that everyone can easily understand. pivot data.xlsx (13.8 KB)
Description is in the workflow inside Invoke VBA Activity.
The function was tested on following scenarios:
Valid data:
a) Making table with only rows, Sum and Count
b) Making table with only columns, Sum and Count
c) Making tables with rows and columns, Sum and Count
Invalid data:
a) wrong sheet name
b) wrong field names (rows, columns)