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