F
fred
Hello,
I wonder if there is a way to prevent user from sorting one
column only, leaving other columns intact.
Ideally, I am looking for the method of "locking" the sheet that way, that
whatever user does to the sheet's columns the data in other columns will be
always related to the original data in that column.
I am writing this, because I had the hard experience with the user who made
a selection of one column data and then sorted it using 'Sort' by Date but
it applied that operation to that particular column only.
As result all data get mixed up, rendering the database useless.
Thanks,
Fred
I wonder if there is a way to prevent user from sorting one
column only, leaving other columns intact.
Ideally, I am looking for the method of "locking" the sheet that way, that
whatever user does to the sheet's columns the data in other columns will be
always related to the original data in that column.
I am writing this, because I had the hard experience with the user who made
a selection of one column data and then sorted it using 'Sort' by Date but
it applied that operation to that particular column only.
As result all data get mixed up, rendering the database useless.
Thanks,
Fred