Finding matching rows on two worksheets
I'm trying to compare rows on 2 worksheets. If there are matches then I want to take the rows off of the 1st worksheet and move it to a 3rd one.
My 1st worksheet consists of "admin calls." Column A is the phone number, H is the date, and F is the start time.
My 2nd worksheet consists of "all calls." Column I is the phone, B is the date, and C is the start time.
I want to look at each row of the 1st worksheet, and try to find a matching row on the 2nd. A match will mean the phone number, date, and start time are all the same. If it finds a match, then I want to copy the value of Column B on the 1st worksheet to Column M on the 2nd. I'll then take the row off of the 1st worksheet and move it to a 3rd worksheet (called "matches").
Any help will be greatly appreciated. This is the last piece of a project I'm working on to make our billing girl's life a lot easier.
If I need to explain anything better then please let me know. I'm posting this question in a few different forums.