Try Debra's page on using a dynamic data source:
http://www.contextures.com/xlPivot01.html
Excel -- Pivot Tables -- Dynamic Data Source
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AT" wrote:
I'm trying to write a macro to create a pivot table, but I don't know how to
designate which cell range to include because it will change on a weekly
basis.