I have an excel report that has several work sheets. In my summary sheet is a
drop down box where the user picks their choice of employees and the pivot
table pulls the data from from other sheets and gives a summary. Is there a
way to print all the employees in that drop down box with a single click,
instead of manually choosing each employee and print it.
Any help will be appreciated.
Thanks in advance.
Shaj

There is no single click solution to your problem and the most appropriate
response will depend on your verison of Excel (pivot tables changed in
xl2002). That being said you can use Show Pages (How to access this button
depends on your version of XL) whic wil create a seperate sheet for each
employee. You could then print all of the sheets. Otherwise you need to use
code which will depend on your version of XL again... Take a look at this
link...

http://www.contextures.com/xlPivot09.html
--
HTH...

Jim Thomlinson


"shaj" wrote:

I have an excel report that has several work sheets. In my summary sheet is a
drop down box where the user picks their choice of employees and the pivot
table pulls the data from from other sheets and gives a summary. Is there a
way to print all the employees in that drop down box with a single click,
instead of manually choosing each employee and print it.
Any help will be appreciated.
Thanks in advance.
Shaj