Formula or Macro for Copied Cell Upon Entry and Sort

Hello all!

First time posting. Cant figure this out for some reason as I believe im overcomplicating it in my head. any help is appreciated!

Problem 1: Im creating a golf pool. I want to copy the cell under the persons picks, with the earnings cell. So as I enter a $1 to signify a persons pick, when i change the earnings number, i want the picked cell to copy it. there will be roughly 50-100 entries.

Problem 2: Once the earnings numbers are in and totals are calculated, how do I order the columns in terms of highest totals from left to right?

to add some colour:

I will be adding columns as people join. I will then enter their picks below name by placing "pick" or "$1". once tournament is complete, I will update earnings numbers, and I would like it to copy to each persons picks. I tried a bunch of IF formulas but as I enter picks, the formula would be overwritten.

Also, any advice on best way to view as I will be sending this out via email in PDF form.

Thanks in advance for the help!


picks example.PNG