Hello to whoever is reading.
I have just sorted a column on a worksheet, but when changing some data and saving, then re-opening it hasn't sorted the updaed values.
Each cell in column 'B' will have either 2 types of values in which will change every few weeks:
1: A date
2: the word "Completed".
I want column 'B' to auto sort itself when openening in the following order: oldest date, newest date, completed. ** For your information: Also column 'B' will be a locked column and the sheet protected. It contains a formula & the values will be auto update based on information from other cells **
I have attached the workbook. Thank you in advance.
Bookmarks