Conditionally copying data to new sheet

diana831

New Member
Joined
Sep 4, 2007
Messages
1
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
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

ICdeadppl

Board Regular
Joined
Feb 21, 2007
Messages
79
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,331
Messages
5,601,006
Members
414,420
Latest member
Richie77777

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top