Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate worksheets fro a Master List | Excel Programming | |||
Updating worksheets from master worksheet based on column value | Excel Worksheet Functions | |||
Macro to populate master spreadsheet from others based on headers | Excel Discussion (Misc queries) | |||
Populate worksheets based on a master sheet | Excel Worksheet Functions | |||
Create a master worksheet based on 2 different worksheets | Excel Worksheet Functions |