PDA

View Full Version : Finding matching rows on two worksheets



Wire323
04-12-2006, 10:08 PM
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.

Thanks.

geekgirlau
04-13-2006, 06:44 AM
Hi Wire323,

Would you please add a link to any other location where you've posted the problem? It saves you having to restate the issue and helps prevent other members spending time on your post if it's been solved elsewhere.

You might also want to attach a sanitised version of your workbook to give us a sample of what you're after.

Wire323
04-13-2006, 12:27 PM
Here are the other places I have posted my question:

Ozgrid (http://www.ozgrid.com/forum/showthread.php?p=251316&posted=1#post251316)
MrExcel (http://www.mrexcel.com/board2/viewtopic.php?p=991689#991689)
Excelforum (http://www.excelforum.com/showthread.php?p=1555426#post1555426)
Tek-tips (http://www.tek-tips.com/viewthread.cfm?qid=1217534)

In order to post the worksheet it would take me awhile to change all of the confidential information. If I get a chance I'll do it.

Thanks

Wire323
04-13-2006, 01:38 PM
I posted a sample of my workbook on Ozgrid (http://www.ozgrid.com/forum/showthread.php?p=251349&posted=1#post251349).
I also explained what I'm trying to do in a little more detail.

Thanks.