I want the contents of 3 cells to move when i add a number in one of them.
e.g
Permanant info in A1 & C1. When I put a number into B1 I want the info in
A1 B1 & C1 to show in X1 Y1 & Z1.
Is that possible
Many thanks