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


--
cscribner
------------------------------------------------------------------------
cscribner's Profile: http://www.excelforum.com/member.php...o&userid=23661
View this thread: http://www.excelforum.com/showthread...hreadid=374094