Hi all ,
I'm new to vba programming. I'm looking for macro to do the following :
On my "data" sheet i have listed info in each column about employees. Column A is headers and it's 20 rows long (A1 Name , A2 Age , A3 Nationality etc.) It looks like this :
A B C
1 NAME James Mark
2 AGE 22 18
3 NATIONALITY English German
4....
5...
20...
What i'm trying to do is to copy all the employees info with the same nationality to new sheet called whatever their nationality is. This way employees from each country will have designated sheets. Once copied there i want headers next to each column as well.
By the same token once this is all done and lets say i cleared content from my "data" sheet how do i get back all those emploeeys to my "data" sheet ??
thanks in advance guys !!
Bookmarks