I need to create Pivort table in VBA macro for below file, it needs to be created in another new sheet in excel. kindly share the vba codes. A B $$ D $1$ CLIENT CODE Quatity $1023$ EKRO EKRO $11$ Item Mango Banana Apple Orange Cocoa UOM No's No's No's No's No's $4$ EKRO $235$ EKRO $86$ EKRO $59$