Kentetsu
Well-known Member
- Joined
- Jan 22, 2004
- Messages
- 520
Due to the protection function, users cannot sort by descending (using filter), and this is causing some problems. So I was wondering if it were possible for the sheet to be sorted automatically whenever the spreadsheet is opened. Is this a viable solution?
The sheet is titled Summary (Sheet 1), and the range is A4:CI301 and I would like to sort based on the data in column C, in Descending order (C4 - C301).
Like I said, I'm not sure if this is the best method or not, so I am open to any suggestions that may be applicable.
You input is appreciated. Thanks...
The sheet is titled Summary (Sheet 1), and the range is A4:CI301 and I would like to sort based on the data in column C, in Descending order (C4 - C301).
Like I said, I'm not sure if this is the best method or not, so I am open to any suggestions that may be applicable.
You input is appreciated. Thanks...