Auto Print

[djfatboyfats]

Afternoon all

I have a sheet that i have to print out every day for each memeber on my team, i have the template set out and a validation list in cell B18 with my staffs names in there, i have to drop down each name and press print.
So what i though is there must be a quicker way so i recorded a basic macro that repeated what i had done, problem there was it printed the same name (Validation name didnt move) so i tried thinking away around it and came up with this.

Please Login or Register  to view this content.

This is not ideal and sometimes misses the first name off the list if another name is already in there.

Does anyone know a better way?

File is also attached