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
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