(Solved) Automatically sort data when new values are entered.

Question

Hello everyone,

I am looking for a way to automatically sort the data in J2:J14 (by largest to smallest) whenever I enter new values into the table below it (Table 2).

Here is a picture of what it looks like:

Answer 1

It's not "automatic", but it is faster than mousing.

What I do is use use the shortcut keys:

With the cursor in the column to sort on (single column)

<ALT><A><SD>

If you are sorting on more than one column first define the sort criteria after clicking on the Data tab > Sort & Filter group > Sort button. Subsequently use <ALT><A><SS><Enter>

Answer 2

re: more on sorting

Also, a Table in Excel includes its own sort capability.

Answer 3

re: questions

Code in Excel almost always refers to VBA code which stands for "Visual Basic for Applications". It is the primary coding language used within Excel.

VBA Event code will function if a cell change occurs from manually entering a value or pasting a value in a cell.

But, but, but Sorting is designed to sort data not formulas.
Formulas can change their cell references when moved to another row.

You can sort cells containing formulas, but you have to make sure the cell references are correct when the formulas are moved.

"QAT" stands for Quick Access Toolbar.

Note: you have an arrow pointing from Table2 to a formula.

I assumed that Table2 contained formulas.

'---

Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

Answer 4

Thanks for responding.

I'm not sure what you mean by "changed value originates from a formula".

In this case, would the original value be the COUNTIF formula (counting if a specific value is entered in Table 2) or the values themselves being added into the table?

Also, what kind of code are you referring to, and what does QAT mean?

Thank you.

Answer 5

Re: automatically sort

Excel has 'Event' code that can run when changes are made to a worksheet.

That doesn't work when the changed value originates from a formula.
(the formula has not changed)

Just add the sort icons to the Quick Access Tool bar.

-or-

Create some sort code and add a button to QAT to run the code.

(no selection would then be required)

'---
Nothing Left to Lose