I have several pivot charts on different sheets of a workboard. I used the
camera tool to put them on 1 main sheet. What I would like to do is, from
the main sheet allow the person viewing the tables to choose either a month
&/or employee and have all the pivot tables show the information related to
that particular month and/or employee. Right now if I go to each separate
sheet and set the month and employee then go back to the main sheet all
information has been changed, but I would like to be able to do it from the
main sheet. Is this possible and if any suggestions on how to do it.
Thanks