Export data from excel and seperate it by cell value automaticly

[GilShmuely]

Hello guys,

I am using excel for listing jobs I do for my clients, and I would like to know if it's possible to export the data and separate it to each client's record in the last month.
I do it manually by filtering to view the last month and a specific client each time, and it takes a long time to do. (I am doing it to print and send them the details together with the invoice)

Is it possible to do it automatically?

Thanks in advance!

 

[aqeelnokia99]

select all your date click sort by selct date colom shot by oldest to newst

 

[GilShmuely]

Hey, thank you for your reply.
I think you misunderstood what I mean. I mean to export a report about each costumer's last month payment details and I don't want to do it one by one by filtering the data and then export it. So I am asking if there is maybe a way to automate it through code or macro?