Multiple Pivot Tables with single Page Field

I've got two pivot tables on a sheet, one showing the selected week's totals, and the other showing the month's totals. I want to link these two tables to update automatically--if someone selects the week of 4/24/2005, then I want the other table to automatically select April 2005. What's the trick to doing this?

thanks!
Craig

You can do this with programming. There's a sample file here:

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

Under Pivot Tables, look for 'Change Page Field'

cscribner wrote:
> I've got two pivot tables on a sheet, one showing the selected week's
> totals, and the other showing the month's totals. I want to link these
> two tables to update automatically--if someone selects the week of
> 4/24/2005, then I want the other table to automatically select April
> 2005. What's the trick to doing this?
>
> thanks!
> Craig
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html