Split excel data into multiple sheets based on Employee ID

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

Hi Hahobe!!

I browsed many threads to track such scenario. I found that the requirements were to split a master sheet into multiple sheets on the basis of particular column. In my case Column A contains Employee ID, Employee Name, Address. I need to split the excel sheet on the basis of employee ID. And every sub sheet should contain all the values for that employee ID i.e Employee ID, Employee Name, Employee Grade, Address and base Location. Also I need that every tab should be renamed as Employee ID - 111011, Employee ID - 111002 and so on... I hope I am able to clarify my requirement.

Regards,
Preeti1309

Pl see attached file with macro.

Hi Sinivas!!!

Thanks a ton!! The script works.. The only issue is..Is there any way to retain the original formatting....?

Regards,
Preeti

hey preeti..!!!

use the following code and enjoy.

HTML Code: 

Thanks & Regards
CA Mahaveer Somani

or u can check the attached file.

hey hahobe,

I assumed that the word "Emplyee ID 111011" is written by mistaken...and i think i m right.


Regards
Veer