VBA generalise code to create pivot table for selected range into new workbook

[shoun2502]

Dear Team,

Greetings of the day.

I need to create a pivot table every time for different ranges , for that I need a code to just select the range and create the pivot into another workbook for data analysis.

Please help me in the code.

Thanks in advance.