I've been working on a very complex spreadsheet that updates as you enter data but I have been asked to do something else that I'm not sure how to do. I have a list of names and whether or not they were hired. I need to put the people who have been hired onto another sheet without spaces. I have provided a example of what I need.

Any help would be appreciated!

http://i127.photobucket.com/albums/p.../excelhelp.jpg