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

[pawcoyote]

I have updated the sample to have the correct headers on both sheets.

I would like to keep this simple. I would like to add the Copy from the Deployment Sheet to the MAFFT Sheet based on the same criteria as the original copy and paste. I identified the fields in the CrossRef tab which fields I wish to copy from the Deployment to the MAFFT.