Printing all from drop down box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box 2
Help Required 3
Excel drop down lists 2
Macro help please! 2
switching out drop down bars 3
Drop down boxes in VBA 1
lookup drop down 1
Drop Down Box 7

Back
Top