Pivot table

[ponn_sugu]

Hi Team,

I have one data in sheet 1 & i need to create pivot table for that data with help of Macro in VB in next sheet

Kindly provide the codings to slove this issue...

I tried to record the Macro but while running in next time Pivot will create one more sheet again......

Regards
Sugumar.P

[DonkeyOte]

ponn_sugu, I appreciate your are (relatively) new to the board but please note the following:

Your post does not comply with Rule 1 of our Forum RULES.
Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search.

Poor thread titles will be addressed according to the OP's experience in the forum:

If you have less than 10 posts, expect (and respond to) a request to change your thread title.

If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


and....


Your post does not comply with Rule 5 of our Forum RULES.
We have several question forums, please choose the appropriate forum for your question

Your question is Excel rather than Word related.

I have moved your post to the Excel Programming forum


Once you have modified your title I'd suggest also posting back with whatever code you recorded and outline your requirements in more detail.


Please ensure that you read and subsequently adhere to all the Forum Rules going forward.

[DonkeyOte]

no response & since x-posted - closed.