auto sort

[esme01]

I have a fairly simple spreadsheet, with the main columns being name, surname, date & notes.

I'm wondering if there is any way to set it to automatically sort into alphabetical order by surname, whenever a new entry is made?

Any help would be appreciated.

Thanks

[Carim]

Hi,

Turn on your macro recorder ...
go through the steps required to sort your worksheet
See how VBA has coded your actions ...

To get this macro to run automatically, add an event macro in your worksheet
module ...

Please Login or Register  to view this content.

[esme01]

Thanks... I've managed to record the macro etc, but my Excel knowledge is seriously limited (hence why I'm here!)... how/where do I add the thing to make it run automatically?

[Carim]

Hi,

The private sub is an event macro to be stored in the worksheet module ...
Go to worksheet tab
right click
select view code
copy code ...