Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help......
I have created a "Time Allocation" spreadsheet/template for our
employees to fill-out. This worksheet must be filled out every 2 weeks and sent via email to the accounting office. I would like to create a macro that will - save the file locally and on a network drive with a name specified within the worksheet - email a copy of the saved file to me and the person who filled out the report Also, if the employee has already filled out a report with the same name, would it be possible to have the file be saved as John-Doe 315204-B (original file being John-Doe 315204) I already have the template set so that....employees pick name and date from drop down and correct file name and their email address will populate 2 different cells on the report using VLOOKUP. Any help? Also, where is a good place to learn VBA/Macro programming. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |