Quote Originally Posted by pawcoyote View Post
My thought was since someone else will be filling in the other fields and if they decide to not have a specific Config SN and Serial Number assigned to that area then it would remove anything that might have been copied over in a prior macro run. I.e. they remove the Config SN and Serial Number but leave the other fields filled in until they decide which to assign. I would like to be able to remove anything that was copied over in a prior macro run.. Did that explain what I wanted to do?

This could also be a second macro to remove the filled in info if there are no Config SN and Serial Number....

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