I have one concern that I have to split one sheet data into multiples sheets.
Based on condition as below.
Main Sheet:"Employeedata"
Columns : Employee Name , Date, Working Hour, Rate, Total.("A:E")
Main Sheet consists of Employee details of all the workshop .(Day wise)
I need to split the Main "Employeedata" Sheet into separate sheet for each of the Individual Employee based on name.
and also when I add new detail in "Employeedata" sheet by deleting old data, automatic append data in particular employee sheet (old data keep as it is so i can maintain monthly report).
if I add new employee automatic create new sheet with employee name.
Would appreciate if any body can provide such macro code.
Thanks in advance
Regards,
Based on condition as below.
Main Sheet:"Employeedata"
Columns : Employee Name , Date, Working Hour, Rate, Total.("A:E")
Main Sheet consists of Employee details of all the workshop .(Day wise)
I need to split the Main "Employeedata" Sheet into separate sheet for each of the Individual Employee based on name.
and also when I add new detail in "Employeedata" sheet by deleting old data, automatic append data in particular employee sheet (old data keep as it is so i can maintain monthly report).
if I add new employee automatic create new sheet with employee name.
Would appreciate if any body can provide such macro code.
Thanks in advance
Regards,