I would like to automate printing in excel. I have an Excel worksheet that
has one worksheet that lists Employer Numbers. I have a second worksheet
that looks up (vlookup) various employer related statistics on various other
worksheets after I drop in the Employer Number. The second worksheet is the
report I would like to print.

Right now it is a fairly manual process whereby I drop in the Employer Group
Number then print worksheet 2. I do this for every Employer Group Number on
my list.

Is there any way to automate this?