Wardylewis
New Member
- Joined
- Jun 7, 2016
- Messages
- 37
Good Evening,
I have a sheet called Employee List which holds information on every employee and what tests they require.
However, when employees need booking in for tests it takes a fair bit of sorting, is very time consuming and messy which leads to data input errors.
I was wondering if there was a way that I could do this automatically with VBA and transfer employees based on a specific criteria.
In worksheet "employee list" I have 25 columns which hold various pieces of data. Need it to start on row 6 and then check down to the end row looking to see if column 25 matches the set criteria.
Employee List
<tbody>
</tbody>
The booking sheet has ComboBox1 which has a value of either 30/60/90 and when a value has been selected and CommandButton1 is pressed I need it to search column 25 on the Employee List sheet and then paste the information from the columns 1 - 7, 13,15 etc and place it into the booking sheet starting from B3.
I have looked online and google all afternoon but cannot seem to get it right. It either throws errors or pastes the data on top of each other.
I am new to VBA so an explanation of how it works and what it is doing would be really useful so I can learn from my mistakes.
Thank you for any support it is greatly appreciated.
I have a sheet called Employee List which holds information on every employee and what tests they require.
However, when employees need booking in for tests it takes a fair bit of sorting, is very time consuming and messy which leads to data input errors.
I was wondering if there was a way that I could do this automatically with VBA and transfer employees based on a specific criteria.
In worksheet "employee list" I have 25 columns which hold various pieces of data. Need it to start on row 6 and then check down to the end row looking to see if column 25 matches the set criteria.
Employee List
Emp ID | First Name | Surname | Dept | Unit | Site | Shift | A | Atime | C | Ctime | F | FTime | Shortest Time |
11 | Mickey | Mouse | Costume | D1 | Disney | Days | Yes | 20 | Yes | 20 | Yes | 20 | -10 |
<tbody>
</tbody>
The booking sheet has ComboBox1 which has a value of either 30/60/90 and when a value has been selected and CommandButton1 is pressed I need it to search column 25 on the Employee List sheet and then paste the information from the columns 1 - 7, 13,15 etc and place it into the booking sheet starting from B3.
I have looked online and google all afternoon but cannot seem to get it right. It either throws errors or pastes the data on top of each other.
I am new to VBA so an explanation of how it works and what it is doing would be really useful so I can learn from my mistakes.
Thank you for any support it is greatly appreciated.