Ideas for VBA logic

[normpam]

So, I've got a list of names in Column C, and in Column E a list of Departments, sorted in ascending order

John Smith 1
Mary Jones 1
Barry Sanders 2
Harry Stevens 3

I have already created VBA code to automatically add sheets and name them based on the list of departments. Now I would like to populate each sheet with the names from Column C, that correspond with the department numbers. So, for example, I need to put the first two names into the Sheet named 1, then Barry Sanders in the Sheet named 2, etc.

I have an idea about how to get it done, but am looking for better ways that would be more logical and simpler.

Any ideas are much appreciated!

 

[Norie]

You could use advanced filter to copy the names for each department to the relevant sheet.