 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Automate 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? 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 > 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 [quoted text clipped - 7 lines] > > Is there any way to automate this? 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. > Hi > [quoted text clipped - 19 lines] > > > > Is there any way to automate this? 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. > 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. [quoted text clipped - 26 lines] > > > > > > Is there any way to automate this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.