shuttlecock
New Member
- Joined
- May 24, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi,
Hopefully someone on here is able to help, i am not familiar with VBA .
i have a leave spreadsheet with 12 tabs for that calculates staff leave, their name in column B and the date in row 2. This workbook is read only for staff and only editable for managers. what i would ideally like is a form for staff to send to managers and for the managers to approve the leave on the form and the form update the leave planner in the relevant tab and date for the employee that has requested.
Would this be possible in excel using VBA to be an automated process
thanks in advance
Hopefully someone on here is able to help, i am not familiar with VBA .
i have a leave spreadsheet with 12 tabs for that calculates staff leave, their name in column B and the date in row 2. This workbook is read only for staff and only editable for managers. what i would ideally like is a form for staff to send to managers and for the managers to approve the leave on the form and the form update the leave planner in the relevant tab and date for the employee that has requested.
Would this be possible in excel using VBA to be an automated process
thanks in advance