Hi

I have this huge table with employee information on one sheet that i want to move to as many sheet as their are employees, giving each sheet the name of the employee, and filling the table information in a specific format in the employees sheet.
Basically it looks like this:

A B C D ...
1 EMP.1 DATA1 DATA1 ...
2 EMP.2 DATA2 DATA2 ...
3 EMP.3 DATA3 DATA3 ...
SHEET1

should be replaced (or at least completed) by:
A B C D ...
1 EMP.1
2 DATA1
3 DATA1 ...
EMP.1


A B C D ...
1 EMP.2
2 DATA2
3 DATA2 ...
EMP.2

A B C D ...
1 EMP.3
2 DATA3
3 DATA3 ...
EMP.3

and so forth. I hope that someone can help.
Thanks

Fanch