Macro for creating two pivot tables

Hi,

I find that using the record Macro function is really useful. Start the recording, do what you need to do manually, stop the recording and then use the code that was stored in the marcro as a 'starter for 10' usually works for me with a bit of tweaking.

ta

PKDJ

Unfortunately, the macro recorder does not use loops or variables...as far as i know. I have accomplished the task of using the same pivot cache to produce two pivot tables, although not simultaneously. Currently, my macro creates a pivot table, copys/pastes to a new sheet, then clears the pivot table fields and creates a new pivot table without reselecting the data, and finally copys/pastes to the recently created sheet.

I want the macro to use loops and variables because soon i will want it to create three or more tables.