Automatic update from one sheet to another

[gmacdaddy89]

I am working on building a database in excel that collects information for fantasy football. I have a worksheet that has the players names and positions on them, and then I have a separate worksheet for each of the individual positions. So the main worksheet has quarterbacks, running back, receivers, etc. all on one. Then there is an individual worksheet for each of those individual positions.

I am wondering if there is a way for the individual position sheets to automatically update if a new player is added to the main spreadsheet. If I were to add Drew Brees, QB to the main players list, is it possible for him to automatically show up on the QB list?

Thanks

[arlu1201]

Gmacdaddy89,

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.