Morning fellows, I am in need of some guidance. I have a list of people that helps me see their "sales". I choose their name, I hit a macro and boom their monthly sales appears. What I need/want is to print that list. And lets say that I have 200 salesman how can I do It in one macro. Select name > run macro >select list > print(or save as pdf with salesman's name) >select next name etc etc. Any help is very appreciated. Thanks