excel 2010

I am working with someone at work who has an Excel 2010 document. In his document, he has a drop down box from a pivot table. When he clicks on the drop down box, a large list of our doctors is listed, and he has to choose each individual doctor, which populates the fields in the excel document with that particular doctor's information, then he can print out the document for that doctor.
He has to do this for each doctor on the list, and it's a BIG list.
So, is there a way to automate a process like this through Excel?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Well I don't know about automation, but I expect the dropdown you are talking about is at the top of the pivot table.  This is the Filters Option,  If you drag that field out of Filters to Rows, you will see all the doctors at one time.  

If you want to only show one doctor per page, you can also use the Show Pages option which will create a new tab for each doctor.  Using the Pivot Table Menu go to Analyze tab (at top of page), Go to Options on the left, Use the dropdown and pick Show Report Filter Pages..

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JeffBeallAuthor Commented:
Sorry I haven't gotten to this. I have to close this for now and revisit it later. Thank you for your help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.