Anybody know the best way to do this expediently? Drag and drop or copy and paste makes them link to the original cell even when $ signs removed.

It does not need to be a VBA solution, but just in case, I posted in this forum. If there a way for the compiler to see the address the checkbox is sitting in, then we could dynamically link to it that way. The box is sitting square in each cell, for checklist purposes