B
Bultgren
I would like to blank and protect certain cells depending on a value in one
cell (A1).
If, e.g. the value in cell A1 is 6, then the users are only allowed to enter
values in the first 6 weeks for that year (=first 6 columns in the table). In
order to avoid problems I would like to erase all existing data in columns
7--> and then lock these cells. Any ideas how to do this?
cell (A1).
If, e.g. the value in cell A1 is 6, then the users are only allowed to enter
values in the first 6 weeks for that year (=first 6 columns in the table). In
order to avoid problems I would like to erase all existing data in columns
7--> and then lock these cells. Any ideas how to do this?