Sorting columns with rows with a fixed "Sort" button

[dmed99]

Trying to figure out how to sort by adding 3 columns together then sort that total by row on the ranking.

I can sort manually by highlighting the grid A3:K15 and clicking on the sort function key at the top. I would like to put a sticky button on the screen for people that do not how to sort or bypass the sticky button and have it automatically sort after entering in the numbers on the screen.

I am not sure that this is possible on either scenario or any other ideas would be appreciated.

[FDibbins]

You could record your own macro (VBA) for this.

1. practice a few times so you hav a good idea of what you need to do
2. SAVE YOUR FILE, in case you mess up, you can get it back.
3. click the "record" button (left bottom corner, looks like a mini-sheet with a red X in the corner)
4. give the macro a name, and store it in this workbook.
5. perform your sort, as you practiced
6. when complete, click the "record" button again (to stop the recording)

That shoud do it, test it again tio make sure it works

check to make sure it worked the way you wanted it to.
To add a "button"...

1. Select Insert tab/Shape/pick a shape
2. "draw" the shape where you want it to be
3. Right-click into the shape/Edit Text and enter your button title.
4. right-click the shape again, click assign macro, and select the macro you just recorded

[dmed99]

Thanks Ford. That was incredible and worked like a charm. I started reading about VBA's and got lost and confused.

Thanks for your help.

Dan

[FDibbins]

You are most welcome If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

[dmed99]

Not sure on how to mark solved or adding reputation to those that helped.

[dmed99]

This post has been solved.

[FDibbins]

See my signature in post #2