Is there any way to lock two Google Sheet cells to each other?
What I need:
I have data in cells A1 , B1 ; A2 , B2 , ...
A1-B2 / A2-B2 must be adjacent.
I need to sometimes copy A1-B1 to different place in the same sheet, but users are copying only A1 without B1.
So if someone copies A1 (without B1) to, for example, D5, I need to automatically copy B1 to E5.
Is that possible?