Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to automate process
I have an Excel workbook. In the workbook is a spreadsheet, sheet1, that
contains employee information. Sheet2 contains work order authorization (WOA). Sheet3 contains the WOA for an employee. Sheet3 is created when a name is copied from sheet one, paced onto Sheet3, and a macro is excuted to pull out all the WOA from Sheet2 based on information for the employee. The macro find the correct WOAs for the employee. Sheet 3 is then manually printed. What I need is a macro that will automate the entire process. Select the name from worksheet1, pace it onto Sheet3, execute the existing macro, and finally print Sheet3 and continue to loop through until WOAs are printed for all 200 employees. Can anyone help me get with this? -- jsm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to automate process | Excel Discussion (Misc queries) | |||
Automate deletion process | Excel Worksheet Functions | |||
How can I automate the process of copying the first letter of a ce | Excel Worksheet Functions | |||
Automate process via button on form | Excel Worksheet Functions | |||
How to automate process of replacing values? | Excel Discussion (Misc queries) |