code to prepare a pivot table from excel file

[Xprnc]

Dear Team,

Please assist me in sharing a Macro code to create an pivot table automatically.

Thanks and Regards

[Aussiebear]

What is wrong with the method provided by excel?