Add data from one sheet to multiple sheet

Closed
HKB - Nov 13, 2016 at 06:51 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Nov 14, 2016 at 04:09 AM
Hello,
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 new data (delete old) in "Employeedata" sheett ,automaticly append in perticular employee sheet.

if I add new employee automaticly create new sheet with employee name

Would appreciate if any body can provide such macro code.

Thanks in advance

Regards,

hkbhansali



1 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Nov 14, 2016 at 04:09 AM
1