How to get macro to pull from excel list in descending order

Actually it would be best to copy all cells at once, and then paste them into the destination app.
I'm pretty sure we've had this or a very similar question before.
You might start with a forum search on "excel"

some examples:

If you can't find a solution, then please post more details.
Please read:
Tip: How Do I Get The Best Answer in the Shortest Time?