i'm currently working on a project that involves a pivot table. I need to print out individual reports for each of our employees. The employee name is an option on one of the drop down menus. I began to create a macro that would print everyone in the drop down menu by copying the line of code and changing the name in VBA. My problem is, there is a lot of turn around at this company and the employee names will be changing frequently. Is there a way to record a macro to print each employee's report and have it change according to the names that appear in the drop down menu? (The drop down menu seems to change as the employees do) I can print out each individual record, but it would be a major waste of time! Please help!