Hi

A macro can do it.

Where do you drop the Employer Group Number ?

Where can I find list of Employer Group Numbers?

Regards,

Per

On 27 Mar., 22:19, JeffH wrote:
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?