hi
am doing monthly attendance using excel. intially i have only small number of people so that i can manage with each excel sheet , nowadays the manpower getting increased.
My idea is, in the first sheet, would like to enter the name of the employee and it should fetch the name and provide the required details like total no of days leave and the OT hours.
whereas now am doing for each employee am having seperate sheet with the above details but to search for individual employees i am using hyperlink
is there any way where i can make it simple and time saving to enter the required details in the first sheet like Name, In-time, outtime, Total hrs worked, standard hrs, OT and from this would like to derive no of days present, absence and OT Hrs
Thanks
Madhan