Formula or Macro for Copied Cell Upon Entry and Sort

[DallyDally]

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

[bebo021999]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[DallyDally]

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.

[JohnTopley]

Not sure I understand: you place $1 for Woods/Jason in Jason cell: if the "Woods" value in Earnings is changed (to $5) the value in the Jason cell is $5 ????

If this is correct, It cannot be done with a formula - it will require VBA.

[DallyDally]

That is correct John. Sounds good thank you. I will repost in correct forum.

Appreciate the help!