multiple If - then statements

[sjp1989]

Hi all,

I am trying to write multiple if then statements and need help. I understand the basics but what I need to do is I have data coming from 2 sources and need to match them each source has identical 8 columns for example

Columns A - H data comes from internal source
Columns I - P data comes from external source

Each have the same data elements such as - Month, Year, Manager, Name etc... up to 8 columns

I need to compare the two

If Column A = Column I
then check if Col B = Col J, if true
then check if Col C = Col K, if true
then etc... all the way to Col G = Col O
If all are true then return "matches" on worksheet2

If anyone can help that will be great

Thanks

 

[sjp1989]

This might have to be in the form of a macro also..