Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate printing
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate printing
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate printing
Based upon my example I drop the Employer Group Number is worksheet 2 which
is my report. The employer group number comes from a list on Worksheet 1. I'm surprised a macro can automate this printing. How does it change from one employer ID to the next after printing? Every month the length of this list changes. "Per Jessen" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate printing
I can create a macro that copies the employer group number from a list and
then print the report. However, the length of the list changes every month so how do I handle this? The print macro should end at the end of the list. "JeffH" wrote: Based upon my example I drop the Employer Group Number is worksheet 2 which is my report. The employer group number comes from a list on Worksheet 1. I'm surprised a macro can automate this printing. How does it change from one employer ID to the next after printing? Every month the length of this list changes. "Per Jessen" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advice on how to automate | Links and Linking in Excel | |||
Limit of # of different custom views & Automate printing diff view | Excel Discussion (Misc queries) | |||
automate printing different ranges on 1 worksheet at different tim | Excel Discussion (Misc queries) | |||
Automate without add-ins | Excel Discussion (Misc queries) | |||
Automate Add-in | Excel Discussion (Misc queries) |