Hi,
Highlight the range, Insert, PivotTable and follow the instructions, it will
ask you if you want the Pivot Table in a new worksheet or the same worksheet

If this was helpful please say yes. thank you

"G L PRAVEEN" wrote:

I am getting the data populated using .Net Application into an Excel
Template. Based on the data populated I want to generate Pivot Table in a new
work sheet.