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?