MACRO: IF THEN Statement (Multiple Criteria Match then Copy)

[pawcoyote]

Howdy,

I would like to be able to do the following in a macro:

I would like an IF statement to meet two criteria if possible before copying cells from the MAFFT sheet to the Deployment sheet.

• I would like to match the “Configured Serial #” and the “Mfg. Serial Number” from the Deployment sheet to the “Oracle Config Serial Number (custom12)” and “Serial Number” on the MAFFT sheet.
  
  • I would like matching based off Column header name and not the position since the columns could change
    
    • i.e. We could add in another column with a new header that is needed.
  
  
• If they match then it will copy the matching Cells from the MAFFT sheet to the Deployment sheet
  
  • The cells are highlighted in Bright Green on the Deployment Sheet and MAFFT Sheet
    
    • Deployment Sheet: Starting Column/Row: E10, AE10 – BZ10, CM10 – DJ10, DX10. Ending Row: 5173
    • MAFFT Sheet: Starting Column/Row: G3 – BL3, CA3 – CT3, CV3 – CZ3. No Ending Row to look in. But if there has to be one then go to 5173.
  
  
• If they do NOT match then you get a message telling you which item does not match
  
  • i.e. Configured Serial # does not match on the MAFF Sheet or The Serial Number does not match on the Deployment Sheet

I have attached a Sample of the Workbook.

Thank you for any help you can provide.