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
Bookmarks