How to insert automatically sorted data into the new list?

[lenagav]

Hello,
I'm looking for something that must be easy but I cannot find it.

I have a long list of cheques and I need to sort it out according to the months.
Now, I need that every month would be on a different list in a way that the moment I type the data on the main list the cheque will appear on the certain list. And it should be also in order of the dates on the cheques.

To do "Filter" or "Sort" won't work because every time I add new cheques I need to do it again - filter, copy to the certain list and sort.

Does anyone know how to solve this? Or probably, there is an easier way to get the reports on each month?

Thank you,
Lena

[tom1977]

Hi
Please send attachment with data (excel file with expected results)

[lenagav]

Thank you, Tom,
That would me the easiest way.
But I need to do a few more similar things with different data.

I really want to understand how to do it myself.
Probably you can help with finding the formula(s) I need, please!
Thank you so much!
Lena

[tom1977]

If You want someone to help You remember that he has to understand what You want. And one small attachment (excel file with expected results) is much valuable that thousand words of description

[kvsrinivasamurthy]

Pl See the attached file.

When you make or change entries in columnas A to E in Sheet1, Data is trafered to Sheet2 and sorted on Date basis.

Worksheet event is used.

Any clarifications welcome.