Split excel data into multiple sheets based on Employee ID

[Preeti1309]

Hello Every One!!!


My requirement is to split my excel data into multiple sheets based on Employee ID cell using macros. I have attached excel sheet with test data for more clarification. The new sheets generated should be named as Employee ID - 111011, Employee ID - 11102 and so on and should have all the data for that employee in it.


Thanks in advance