Jun 01 2022 02:09 PM
I am new to excel. A friend set a spreadsheet up for me to use for my checkbook ledger. I would like to have the first column for the transaction date automatically keep the dates in chronological order when I enter new transactions. Is this possible? My friend set up the formula for me to automatically total the Balance column at the end.
Jun 01 2022 02:18 PM
I wouldn't recommend sorting the data fully automatically:
It's not that difficult to sort the data manually from time to time.
Or, if you prefer, it would be possible to create code that sorts the data when the workbook is opened and/or when the workbook is opened. This does not have the disadvantages mentioned above.