I have a Worksheet which has a master list of all employees. There are 3
columns of information (First Name, Last Name @ Department). I want to
create a worksheet for each of the 3 departments and have each worksheet
populated with the information for that department only. The reason I
created the Master List is that people can move between the departments so I
was hoping to update the Master List and then have the Department
worksheets automatically update.

The 3 departments are PT, FR and OF. Is there any code (say an On Change
event) which would look at the Department Code for each line on the Master
List and Copy the information (First Name, Last Name and Department) to the
appropriate worksheet (worksheets are named Master, PT, FR and OF).