VBA To Copy and Paste A Range After Changing 1 Cell

Hello, I hope all is well.

I have an excel spreadsheet where all I need to do is run the following loop:

(1) Change Cell Sheet1_$G$11 to Sheet2_$Y21 (starts with Y21, then after the loop it should go down one and repeat the process)
(2) Once this is done, sort a table I have from Sheet1_$A$20:$U$15053 by M (ascending so highest # is at top)
(3) Then copy range Sheet1_$G$21:$U$21 (since this will be the highest row once ascending) and paste special (values) this range in Sheet2_$Z21
(4) Start over by changing Cell Sheet1_$G$11 to Sheet2_$Y22 and repeating the process.

Can anyone please help? Thanks!

Had a friend send us this over to try but it's unfortunately not working correctly. Any help?

Please Login or Register  to view this content.

It would be easier to help if you could attach a copy of your file (de-sensitized if necessary). Include a sheet showing the expected results. Also, when you sort by "ascending", the data will be sorted with the lowest number at the top not the highest number. If you want the highest number at the top, you would have to sort by "descending". Please clarify.