Hi

I have a spreadsheet with five sheets and I would like to develop a macro,
if possible that creates the pivot tables that I require.

I only want the pivot table to count. Can anyone give me a code for pivot
table macros

Column A is the Row Area
Column B is the Column Area
Column B is the Data Area

using the same data I then want to create another pivot table with
Column C as the Row Area
Column B is the Column Area
Column B is the Data Area

I would like the pivot tables to be displayed on the same sheet