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
There is no attached. A workbook would be helpful.
Here's some code that I use for this job, you will need to change Column references
Please Login or Register to view this content.
Last edited by royUK; 11-18-2010 at 01:59 PM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
This works in your example
I'll add some code to separate workbooks laterPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks