srikanthess
New Member
- Joined
- Apr 11, 2014
- Messages
- 21
Hi All,
I am creating an attendance workbook, Each month will be on its own worksheet.
Emp.No ____ Name_____ Date_____Time In_____Time Out_____Overtime
When I press "Next" Button the entry will be Copied and Pasted on a separate "Roster" table and the entry field is ready for next employee detail. So the roster table is populated everyday.
Now what i am intending to do is,
1. As I enter "Emp.No", all previous attendance for the month of this specific employee should be fetched from "Roster" table and displayed as a table below Data entry row.
2. I want to use a command button which would sort "Roster" table by Employee number and date so that i can edit any wrong entries on a later date. This sorting will help the user to easily pick wrong entries.
I appreciate any help, and thank you all in advance.
srikanth.
I am creating an attendance workbook, Each month will be on its own worksheet.
Emp.No ____ Name_____ Date_____Time In_____Time Out_____Overtime
When I press "Next" Button the entry will be Copied and Pasted on a separate "Roster" table and the entry field is ready for next employee detail. So the roster table is populated everyday.
Now what i am intending to do is,
1. As I enter "Emp.No", all previous attendance for the month of this specific employee should be fetched from "Roster" table and displayed as a table below Data entry row.
2. I want to use a command button which would sort "Roster" table by Employee number and date so that i can edit any wrong entries on a later date. This sorting will help the user to easily pick wrong entries.
I appreciate any help, and thank you all in advance.
srikanth.