Am using a timesheet in excel 2007 column , with details LIKENAME , 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