I see what your saying without a reference point. I don't want to delete the rows just the info in the cells that could have copied over data. How about a separate Macro that looks at the Config SN and MFG Sn on the Deployment sheet. IF those are empty it clears that same cells as we are copying over too? So same macro but no ref to MAFFT just to itself and to clear/delete the cells contents if Config and MFG SN are empty or blank?
Quote Originally Posted by Paul_Hossler View Post
If they delete the Config SN and SN for an entry on 'Deployment' but leave the other fields, there's no sure way to reference back to the source on MAFFT

Since someone could make manual changes to a 'Deployment' line, there's no easy way to see if something was copied over or manually changed/entered.

A second macro to delete rows in 'Deployment' if Config SN and SN are blank is easy