Macro Code for Splitting one sheet data into multiples sheets

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

Thanks vcoolio
Your code is working fine but when i input new data in Main Sheet:"Employeedata" (deleting old data i.e. yesterday's data) and input today's data
then individual employee sheet ADD new data keeping old data as it is.

is it possible?

Exactly yes, that I am expecting.

Hello Hkbhansali,

Perhaps the following modified version of the code will do the task for you:-

Please Login or Register  to view this content.

This code also clears the data from the Main Sheet except for the employee name once the data transfer is complete. This way, you can add new data for each employee without typing in his/her name again. All older data will remain in each individual sheet.

I've attached my updated test work book for you.

Cheerio,
vcoolio.

P.S.: BTW, you've been around the forums long enough to know how we feel about cross posting without notification:-

http://ccm.net/forum/affich-938899-a...multiple-sheet

Please bear this in mind in future. I'll make note over at CCM or even delete the post from there.

Thanks vcoolio,
Hats of you
Perfect...
but little modification require
column "A" also clear from Main sheet, because employee are changing.
and Individual Employe Sheet Start with his Name.

I've attached my modified test work book for you.

Thanks a lot vcoolio,

Thanks for removing the word EXPECTATION and adding the world HAPPINESS to the dictionary of our friendship.

hkbhansali