Far more realistically, you wouldn’t wish to sort just one column. You'd be aiming to sort multiple columns of data by day. Suppose you've got a dataset as shown underneath exactly where you should sort it based on the day in Column A. Recording on the macro commences straight away https://www.customguide.com/excel/autofit-excel