I need to make a Spreadsheet that Checks 2 columns and matches the ones that have a common value. I dont use excel ever but there has to be an easier way to do this than going through it one by one and copying and pasting. thanks for your help!

Try out using Find Function

http://vbadud.blogspot.com/2007/10/e...ll-method.html can help you out

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)