jandrews102675
New Member
- Joined
- Feb 20, 2015
- Messages
- 8
Afternoon guys, I've got an issue with the current spreadsheet I'm designing.
Essentially, we're having to monitor the ad-hoc hours worked by employees (only a small number of employees, 20 max). I've got the spreadsheet set up, with their personal details in one sheet, and then another 'database' sheet set up to log any ad-hoc hours registered against the employee.
The manager of the admin team who'll be inputting the data doesn't want the admin team to input directly to the spreadsheet because of various issues with their ability. So, I've created a Front Page, where they type in the Employee Number, the date a manager has requested the employee to work, and the amount of hours (decimal not minutes and hours) they'd like the employee to work - and the manager's name. This will then return (using various formulae) the Employee's name, their contracted hours for the week they're being requested to do ad-hoc work, and any previously logged ad-hoc hours for that day/week so that we can ensure they're not exceeding the hours they're allowed to work due to visa restrictions. This is all fine, I've got this all sorted however...
I now need to get the information they've input (Employee Number, Date Required for Work, No. of Hours Required and Manager) into the 'database' spreadsheet without the admin staff going into the sheet and typing it in. Initially I was going to use a UserForm to populate the 'database' sheet for ad-hoc hours but this would then require typing the information they've already input again, any ideas how I could remove the need to re-input the information and just move the information they've already input into the 'Home Page' to the 'database' sheet'
Summary (Tl;dr): I've got a spreadsheet, three sheets, 'Home Page', 'Personal Info' and 'Ad-hoc Hours'... our admin staff need to check ad-hoc hours using the 'Home Page' but the info they input into this sheet needs to go into 'Ad-hoc Hours' - I need this to happen without them going into the other sheets and re-typing - any VBA that'll move it across?
I know the answer is most likely going to be VBA, but I've little experience with writing in VBA so any advice would be greatly appreciated.
Essentially, we're having to monitor the ad-hoc hours worked by employees (only a small number of employees, 20 max). I've got the spreadsheet set up, with their personal details in one sheet, and then another 'database' sheet set up to log any ad-hoc hours registered against the employee.
The manager of the admin team who'll be inputting the data doesn't want the admin team to input directly to the spreadsheet because of various issues with their ability. So, I've created a Front Page, where they type in the Employee Number, the date a manager has requested the employee to work, and the amount of hours (decimal not minutes and hours) they'd like the employee to work - and the manager's name. This will then return (using various formulae) the Employee's name, their contracted hours for the week they're being requested to do ad-hoc work, and any previously logged ad-hoc hours for that day/week so that we can ensure they're not exceeding the hours they're allowed to work due to visa restrictions. This is all fine, I've got this all sorted however...
I now need to get the information they've input (Employee Number, Date Required for Work, No. of Hours Required and Manager) into the 'database' spreadsheet without the admin staff going into the sheet and typing it in. Initially I was going to use a UserForm to populate the 'database' sheet for ad-hoc hours but this would then require typing the information they've already input again, any ideas how I could remove the need to re-input the information and just move the information they've already input into the 'Home Page' to the 'database' sheet'
Summary (Tl;dr): I've got a spreadsheet, three sheets, 'Home Page', 'Personal Info' and 'Ad-hoc Hours'... our admin staff need to check ad-hoc hours using the 'Home Page' but the info they input into this sheet needs to go into 'Ad-hoc Hours' - I need this to happen without them going into the other sheets and re-typing - any VBA that'll move it across?
I know the answer is most likely going to be VBA, but I've little experience with writing in VBA so any advice would be greatly appreciated.