Sort column A depending on entries in another column

Hello guys.

I want to sort column A by ascending dates prioritizing specific entries in column R. Whatever cell in column R that contains "O" must be at the top of the list sorted by ascending dates. In the other hand, whatever cell that contains "C" must be at the bottom of the same list also sorted by ascending dates. Good news is that I managed to do that with filters. Bad news is that whenever I want to perform this sorting, I have to manually go to Sort > Custom Sort > and add the two levels. It is kind of a hassle to do that everytime I need to sort data, and it happens frequently.

In my research I found that I can possibly turn the entire worksheet into a table, but since I have a couple of macros and conditional formattings already set, I don't really want to take this risk.

Maybe create a button and assign a macro to it would do the trick?

I appreciate any help.

Hi FDibbins. Thanks for the reply.

Not really. It doesn't need to be sorted as I insert data. I actually prefer to click somewhere to have it sorted. I just really want to avoid the hassle of creating sort criterias everytime I want to sort data.

Hi FDibbins. You are right. There's a way to easily sort data with a kind-of stored sort criterias. After reading your reply, I checked the sort button in the home/editing ribbon and there's a "Reapply" button (Ctrl+Alt+L) just there! Me dumb. Sorry!

Screenshot 2015-06-25 19.57.08.png