Populate 2 worksheets based on a master.
 

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

Populate 2 worksheets based on a master.
 

On Thursday, 9 October 2014 11:59:13 UTC+2, Neil Robinson wrote:
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




--
Neil Robinson

yes, it can be done, with initially concatenation, then countif, and then sumif.

I use it a lot, list me all the kids play hockey on day 1 slot 1, and then slot 2, thereafter list day 2, slot 1 and 2. I use it for an attendance resister.