Need help building macro to auto sort two columns of data

[staralfur]

Hi, I have a worksheet and I'm trying to create a macro that will automatically sort two columns of data. I have attached a version of the worksheet I am using with the data wiped out and replaced with random information for privacy purposes. I'm looking for a macro that will auto sort ranges AO:AQ and AS:AU, which I am using to populate the two graphs at the bottom of the page. I want these columns to update any time the numbers change. (If it matters, the numbers in the original worksheet are driven by formulas, as opposed to this version where I just copied and pasted random values.) I am looking to sort (in descending order) the values in yellow columns AP and AT. There are headers in row 1. Any help you can provide would be MOST appreciated. I've spent hours trying to tweak various code snippets from the macro recorder, forums and websites, and have not found anything that works for me. As is probably obvious, I am a very novice VBA user, so the closer you can get me to formulating something that works without a lot of editting, the more helpful it will be.

Much thanks for all your help.