Formula for auto sorting

[bbenaway]

I need a formula that will automatically sort sheet 2, from info entered on sheet 1 column b with numbers and carry over with it column A containing names, to sheet 2. Sheet 2 will automatically sort column b from smallest to largest and carry colume A with names, each time an entry is made to sheet 1:

Sheet 1

Column A-----------------Column B

Fred Smith------------------55
John Jake-------------------35
Susy Q----------------------66

 

[SkipVought]

Hi,

There are no formulas that SORT.

Use your data on Sheet1 as the source for a Pivot Table on Sheet2. If you make the table on Sheet1 a Structured Table via Insert > Tables > Table, then all you need do is Refresh your Pivot Table and it will reflect added rows in your Structured Table.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]