I have just recorded a macro to create a pivote table. The problem is,
everytime i run the macro a new worksheet is created. What do I have
to change in the macro code to direct the pivote table to be created
in an exiting worksheet (pre-named) instead of setting up new
worksheet everytime I activated the macro button.

Many thanks,
Ola.