automatically populate worksheet

[Maggie]

Hello,

I have a spreadsheet that shows all games for baseball season tickets. The
owner of the tickets is splitting them with two other people. He would like
to be able to choose which person is receiving each game from a drop down (I
know how to do that), and on a separate sheet for each person, have a list of
only the games that that person will have tickets to. Any ideas?

Thank you in advance!

 

[Luke M]

Simple method would be to have
=IF('Sheet1'!B2="Person1",'Sheet1'!A2,"")

Assuming games are listed in column A, persons in column B. Note that this
would create blank rows. (but you could filter this)

Another idea would be to create a PivotTable. You could setup the people as
a page field, and the games as a row field. Put nothing in columns or data.
Now, with a quick selection in the Page field, you can see what games each
person has.

 

[Maggie]

Ok, I had done the if statement, but I didn't like the blank rows. I hadn't
thought about filtering it! Thanks!!