Hi ,
What code would I need to create an individual Pivot for data in each sheet
within a workbook , all sheets have the same headings but different number of
rows and all pivots will be the same .
or
If I create a master pivot from the data in all the worksheets , could I
break it up so that each page field is a seperate tab showing the relevant
Pivot.
Thanks,
sidm

--
Message posted via http://www.officekb.com