Question: Please write a VBA macro code to create a pivot table for this data set. It has 9 9 6 rows. table [ [

Please write a VBA macro code to create a pivot table for this data set. It has 996 rows.
\table[[Invoice ID ,Branch [, City _,Customer type,grad Gender,grad Product line,grad Unit price ,grad Quantity,grad1,|lax5%|grad,Total,Date,Time,Payment L,gradcogsgrad,gross margin percentage,,gross income |grad|,Rating,grad],[649-29-6775,B,Mandalay,Normal,Male,Fashion accessories,33.52,1,1.676,35.196,2/8/190:00,0.646527778,8 Cash,33.52,4.761904,4762,1.676,,6.7,-2],[189-17-4241,A,Yangon,Normal,Female,Fashion accessories,87.67,2,8.767,184.107,3/10/190:00,0.511805556,6 Credit card,175.34,4.761904,4762,8.767,,7.7,-,]]
 Please write a VBA macro code to create a pivot table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!