Matching Values and Copying to A new sheet.

[adienspade]

I have been searching through the forums for examples and haven't been able to find exactly what I am looking for.

Ok here is my issue. I need to compare the Conf # and line number on both sheet 1 and 2. So basically if the Conf # and the Line number match between page 1 and 2 then it copies the Conf #, Item Number(Sheet 1), and Detail(Sheet 2) to sheet 3 in a row. This needs to continue till the end of the Sheet 1. I have a pseudo report created with no code because I don't have a clue as to where to start.

If anyone can give me a push in the right direction I would greatly appreciate it.