Hi,
Does anyone know the best way to do thw following...
I want to have a master list (on 1ist worksheet) that plots a grid of people (rows) vs classes (columns). If the user adds a new person, they will add a new row with their name in the first column, then will put an X (or something) in each column for which they want to sign up for a class. So here's my question...I want to have a separate worksheet for each class. So say, for example, Sheet 2 represents one of the classes. I want to list out the people who have signed up (have Xs in the appropriate column for that class). I know how to use IF THEN to place the people's names on the new sheet IN THE SAME CORRESPONDING ROW as on the main sheet, but do NOT know how to group them so there aren't huge gaps between the names. Is it possible to do this with IF THEN. Or is there a better command. Or is this the funcationality of pivot tables? I'm obviously not well versed on how to approach.
Thanks!!!
Jilli
Does anyone know the best way to do thw following...
I want to have a master list (on 1ist worksheet) that plots a grid of people (rows) vs classes (columns). If the user adds a new person, they will add a new row with their name in the first column, then will put an X (or something) in each column for which they want to sign up for a class. So here's my question...I want to have a separate worksheet for each class. So say, for example, Sheet 2 represents one of the classes. I want to list out the people who have signed up (have Xs in the appropriate column for that class). I know how to use IF THEN to place the people's names on the new sheet IN THE SAME CORRESPONDING ROW as on the main sheet, but do NOT know how to group them so there aren't huge gaps between the names. Is it possible to do this with IF THEN. Or is there a better command. Or is this the funcationality of pivot tables? I'm obviously not well versed on how to approach.
Thanks!!!
Jilli