How to filter out data to separate sheet?

Closed
eren1905 Posts 1 Registration date Wednesday October 14, 2015 Status Member Last seen October 14, 2015 - Oct 14, 2015 at 03:55 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 14, 2015 at 04:17 PM
Hello Guys,
Can someone pls help me out with this problem I am having.

I have 5 drivers on payroll for a car service company.
I have all the airport runs on excel file, around 500 runs.

A. Name of the town
B. Rate
C. Drivers name

I want excel to pull out each airport run to specific drivers sheet so I can easily see their runs and pay them on percentage based on each job they do, in stead of manually copy/paste it to separate sheet.

Please help me creating the formula. Thank you!

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 14, 2015 at 04:17 PM
eren1905, Good afternoon.

You can do this task using VLOOKUP, HLOOKUP or INDEX + MATCH functions.
It depends on which layout you have.

Please, save an example of your file at a free site www.speedyshare.com and put a link here to download
Remember to put data enough and show us how you want the final result.

This way will be possible to help you in a conclusive manner.
0