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 .
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 detail in "Employeedata" sheett ,automaticly append in perticular employee sheet
if I add new employee excel automaticly create new sheet with employee name
Would appreciate if any body can provide such macro code.
Thanks in advance
Regards,
hkbhansali
Bookmarks