Copying Parts of Lists

[evw2k]

What I have is a list of names, then another two columns with yes or no values in them. like so...

Names Trip 1 Trip 2

Name 1 yes no
Name 2 no yes
Name 3 yes yes

what i want is for the names to go to another tabbed spreadsheat like so...

Trip 1
Names Paid

Name 1 yes
Name 3 yes

How do I do this in excel without having to copy paste every name? I can get it to work sort of, but the names copy into the second list in order and you get a fragmented list.


Also, I need to tally the yeses and nos. How do you do that, because they aren't numbers? I'm guessing =if(B2:B30="yes",+1,+0) or something like that, but it didn't work.

[jobo]

Re your second problem

If name/trip1 = no then leave the cell blank
In a cell B32 at the bottom of the trip 1 Column enter the formula
=Count(B1:B30) assuming A1 is the first name and A30 is the last.
This formula will count the yes cells ie the cells which have an enter and ignore cells which are blank ie the no cells.

[jobo]

Re your 1st problem
Read my post to the thread
Automatically generating day and date on several sheets

jobo

[evw2k]

Okay, your answer to my second problem worked. However, I think I didn't make myself clear about the first one. If you look at the diagram I pasted, next to the name of the person, there is a cell that says either yes, they will attend trip 1, or no they will not attend. Then, in the other tab referring only to trip 1, it automatically copies and pastes the name of the people who said yes, they will go on that trip, but not the people who said no. How would I get it to automatically copy the names of the people who said yes?