automatically populate worksheet
 

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!

automatically populate worksheet
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Maggie" wrote:

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!

automatically populate worksheet
 

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

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Maggie" wrote:

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!