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

thanks!
Crai

--
cscribne
-----------------------------------------------------------------------
cscribner's Profile: http://www.excelforum.com/member.php...fo&userid=2366
View this thread: http://www.excelforum.com/showthread.php?threadid=37409

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