Debra Dalgleish has some techniques at:

http://www.contextures.com/xlPivot04.html



AyPee wrote:

The spreadsheet gets copied each month to a new file and the data cleared
out, BUT the selecetion in the Pivot Table still holds the data from Previous
spreadsheets

--

Dave Peterson