Conditionally copying data to new sheet

[diana831]

I have a taxi company, and I would like to set up excel as a central dispatch sheet, containing all calls for all drivers, and then have it automatically copy all the runs for each specific driver to new sheets. Is there any way I can do this without going through and manually copying each run for each driver over?

Example:

Dispatch sheet:
Driver - Pick up - Drop Off - Fare:

Paul - - - Here - - There - - - $7
David - - Here - - There - - -$15
Paul - - - Here - - There - - -$17
David - - Here - - There - - -$10

Paul's driver sheet:
Driver - Pick up - Drop Off - Fare:

Paul - - - Here - - There - - - $7
Paul - - - Here - - There - - -$17

David's driver sheet:
Driver - Pick up - Drop Off - Fare:

David - - Here - - There - - -$15
David - - Here - - There - - -$10

 

[ICdeadppl]

If you want a simple solution then try the following
1. Add column Headings to your spreadsheet
2. Select the range of Data incl headings
3. From the menu choose Data>Filter>Auto Filter

For a slightly more complicated approach this thread has a example file attached, to setup the names as a pick list.

http://www.ozgrid.com/forum/showthread.php?t=27649