Extract data from one file to individual files

[AZHAR CM]

Hai,

I am a new user and happy to see you all here.

I have a payroll file(attached).

Fields are ID, Name, Basic Salary, Food Allowance, Transport Allowance, Tax and Net pay.

Please explain me how to extract individual employees details in individual excel sheet and stored in desktop. And rename the excel sheet as the respective employee name.

Thanks.

Azhar CM

 

[Asheesh]

Check if the below links help...
http://www.datapigtechnologies.com/ExcelExplosion.htm

http://www.extendoffice.com/documen...into-multiple-worksheets-based-on-column.html