Dear Friends,
Am using a timesheet in excel 2007 column , with details like Name , Employee id , designation, Date , time in and time out.
Every day time in and time out with date for each person entered in same sheet.
By month end , i need to segregate , for each employ based with his name...
so i need to know how to copy automatically multiple rows with same name to be copied to new worksheet
Thanks for your help in Advance
Soman