Hi There,
I have 2 sheets Mpro and Employee each with 2 columns
Employee
MPRO | Trips
15 | 1
15 | 1
54 | 3

Mpro
MPRO | Trips
15 |
54 |

I require the code in VBA as an excel formula was slowing the program down.
What I need is where the Mpro.Mpro column = the Employee.Mpro column then the Mpro.Trips column should = Employee.Trips
The trips column for each MPRO will always be the same.
Thanks.