Find Value, Copy Cells, Sort

[mlarson]

Hi all, hoping you can help me with this. I would like to do the following:

-If the value of a cell in column S (on Sheet2) is greater than 1000, then copy the contents of that same row’s cell S, U, AH, AU, BH, BU, CH, CU, DH, DU, EH, EU, FH to a row in Sheet3 in columns B-N starting with row 2 (so it would be B2, C2, D2, …, N2).

-Then sort the rows in Sheet3 by the values in column B from highest to lowest.

Thanks for your help!