OK.. so i have a sheet with a list of people with there name number event ID etc etc....I want to put all the people with event ID =1 in a different sheet ,event id =2 in another sheet and so on ...I tried some Formulas but in vain .. pls help !...