How to create a dynamic macro coding to create pivot table

[thlee1122]

Could you please tell me VBA coding that I can use to create a dynamic pivot table on a new sheet?

Below is the sample dataset that I want to create pivot table with.

Promotion Name Product Code DC(/Unit)
LG SP-2015Q3-SPIFF-STUDIO-001 LSSG3016ST.BSTESTD 75
LG SP-2015Q3-SPIFF-STUDIO-001 LSMC3086ST.BSBESTD 40
LG SP-2015Q3-SPIFF-STUDIO-001 LSMC3086ST.BSBESTD 40
LG SP-2015Q3-SPIFF-STUDIO-001 LSFS213ST.ASTCNA0 60
LG SP-2015Q3-SPIFF-STUDIO-001 LSFS213ST.ASTCNA0 60
LG SP-2015Q3-SPIFF-STUDIO-001 LSFD2591ST.ASTCNA0 80
LG SP-2015Q3-SPIFF-STUDIO-001 LSFD2591ST.ASTCNA0 80
LG SP-2015Q3-SPIFF-STUDIO-001 LSFD2491ST.ASTCNA0 80
LG SP-2015Q3-SPIFF-STUDIO-001 LSFD2491ST.ASTCNA0 80
LG SP-2015Q3-SPIFF-STUDIO-001 LSMX211ST.ASTCNA0 70
LG SP-2015Q3-SPIFF-STUDIO-001 LSMX211ST.ASTCNA0 70
LG SP-2015Q3-SPIFF-STUDIO-001 LSSB2791ST.ASTCNA0 200
LG SP-2015Q3-SPIFF-STUDIO-001 LSSB2791ST.ASTCNA0 200
LG SP-2015Q3-SPIFF-STUDIO-001 LSSB2691ST.ASTCNA0 200

Could you please help me create a macro coding that creates pivot table of this data into a new sheet and put "promotion name", "product code" in the row label and put "DC(/unit)" in the value section? (I want this code to be dynamic)

 

[HolyExcel]

This should help

https://www.youtube.com/watch?v=RPcFEZ_QyI0

or maybe this

https://www.youtube.com/watch?v=xYNTcYNQyU0