Add data from one sheet to multiple sheet [Closed]

Report
-
Posts
1278
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 16, 2021
-
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 reply

Posts
1278
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 16, 2021
220
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!