Macro for sorting rows based on dates in column G

[Scotcel]

Hi everyone. I have a spreadsheet for ppl who attend a rehabilitation day program. The columns are A to M and the rows are from 7 to 32. I need the rows to re-sort themselves based on the dates in column G. Not sure if this matters but the dates in column G are a result of a calculation based on initial completion date (column e) and sick days in column F. It would be awesome if the rows resorted simply whenever data is entered anywhere but even if they re-sorted on opening the file would be brilliant. Thanks everyone. Appreciate your time.

Glenn

[nathansav]

record yourself doing it, then use that. Sort by column G

[JOHN H. DAVIS]

Can you attach a file with some dummy data and your sheet layout? Click Go Advanced button, scroll down to the Manage Attachments button, browse to the required file, and then push the Upload button.

[Scotcel]

Thanks very much John. This is the file that i'm working with. Cheers, Glenn