Hi,
I am using the latest version of Microsoft excel (.xlsx).
In a column, I just want one cell to be filled (at any time) and rest as
locked; but that cell could vary/be different.
And I should also be able to delete that cell and then be able to write on
any other cell on the same column (only one cell should be filled at any time
and rest should automatically be blocked). And I want this for say 100 rows.
E.g.:
Column A is the €˜timing slot; Row 1 is with the €˜staff name; and column B
to ZZ are blank where I will be putting €˜yes in each column but for one cell
only and if I try to enter €˜yes in another cell in the same column €“ it
must not allow me to do so until I delete the earlier entered/completed cell
(ie until I don't delete the €˜yes in the other cell of this column).
Thank you very much in advance. Your help would be highly appreciated.