Automate producing, password protecting and sending Excel timesheets [Macros/VBA]
- or -
Post a project like this2007
£100(approx. $125)
- Posted:
- Proposals: 16
- Remote
- #2156175
- PRE-FUNDED
- Awarded
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
I am certified Microsoft Professional.. With 20 year plus experience in IT, I am expert Excel , VB and VB.net and Python programmer, Desktop Aplications & MS Office Integration and automation
Lahore
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
190114354954864956498658385961104630114452914494731467017179269418894542247736
Description
Experience Level: Expert
I need to improve a payroll process and I think VBA will be the solution.
We have multiple sites (about 40).
We have 2 staff lists (salaried and hourly) for all staff (about 800 employees in total) at all sites (all with unique identifiers for sites and staff) and need to get these into individual excel timesheets (Name, Hours, rate of pay) per site. e.g. 10 employees for site 1, 15 employees for site 2 etc.
These timesheets then need password protecting with an different password per file (all available in another excel list)
These timesheets then need e-mailing out to the sites for completion and return to the payroll team.
I know macros and VBA are the solution, but need that help!
Thanks!
We have multiple sites (about 40).
We have 2 staff lists (salaried and hourly) for all staff (about 800 employees in total) at all sites (all with unique identifiers for sites and staff) and need to get these into individual excel timesheets (Name, Hours, rate of pay) per site. e.g. 10 employees for site 1, 15 employees for site 2 etc.
These timesheets then need password protecting with an different password per file (all available in another excel list)
These timesheets then need e-mailing out to the sites for completion and return to the payroll team.
I know macros and VBA are the solution, but need that help!
Thanks!
Andy M.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
9 Oct 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Are you looking to VBA both the send out and return of data or just the outward process?
717051
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies