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. |
All times are GMT +1. The time now is 07:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com