Logic check - Is this correct?

1. Run macro MAFFT2Development

2. After current logic, add new logic to

If you remove Config SN or MFG SN on the Deployment Sheet I would like for it to remove or clear the data that was imported in from the MAFFT tool (Fields in the CrossRef Sheet) when I run the macro.
3. On Deployment if "Configured Serial #" OR "Mfg. Configured Serial #" is blank, then how to identify the lines on Deployment since those are the two link fields?


I would like to also be able to copy over these columns from the Deployment Sheet to the MAFFT Sheet based off of the same criteria as copying from the MAFFT to Deployment. Deployment sheet Headers, Company, First Name, Last Name, Address1, Address2, City, State, Zip, Phone, E-Mail Web Address from the Deployment Sheet to the MAFFT Sheet with Column Headers that are equal.

4. Is this a new macro?

5. Is this the logic:?

If 'Deployment' [Configured Serial #] = 'MAAFT' [Oracle Config Serial Number (custom12)] AND 'Deployment' [Mfg. Serial Number] = 'MAAFT' [Serial Number] Then

Copy the Col D fields for that line from Deployment to MAAFT

?