Hi,

In the attached I have a list of employees from different countries:

CAN
ESP
FR
GER
UK
US

The country code is in Column B.

I would like a macro which takes this workbook and creates 6 different workshhets
for each country, with each worksheet containing employees from that respective country

Thank yoiuo