create new workbook based on condition

Hi,

I wanted to create a application, like i have excel sheet contains 1000s of employee details, at the end of the column (Column H), managers name will be there.(Ex: 9 Managers).

I wanted to create a excel workbook for each manager that has to save in the path where the original excel located.