Automate producing, password protecting and sending Excel timesheets [Macros/VBA]
- or -
Post a project like this2018
£100(approx. $125)
- Posted:
- Proposals: 16
- Remote
- #2156175
- PRE-FUNDED
- Awarded
AAT Licensed Accountant and Full Member (MAAT). Xero Certified & Silver Partner
Peterborough
2267477238704223961932399333
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