Autosort when new data is entered.

Enter data on sheet 1. Autosort data on sheet 2 when any new data is entered in column "F" on sheet 1. Is there a macro to do this? I don't know any VBA, can I record a macro to do this for me? Thanks.

Hi nickm0501

Welcome to the forum

You would do best to post a sample workbook showing your sheet layout and what columns/tables you need sorted.

It should clearly illustrate your problem and not contain any sensitive data.

In the meantime, does this look like what you are trying to do?
Change the values in column B to see it work.