How to filter out data to separate sheet?

Closed
Report
Posts
1
Registration date
Wednesday October 14, 2015
Status
Member
Last seen
October 14, 2015
-
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
-
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 reply

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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