Hi,

Sorry if my description isnt very clear but here goes... I have a master list of members on Sheet1 - Name, email, age, gender, membership type.

There are two different membership types, A and B. I want to automaticly populate Sheet2 with the details of everyone who has memebership type A and sheet3 with everyone who has type B. Can this be done?

Thanks

Neil