Sorting data in sheets

[Cel]

Hi

I want to have a specified range appear in a form, sorted by one row in
the range.

Like this on the sheet:

x b a 3
b a x 1
b b a 2

....and like this on the form (sorted by the last row):

b a x 1
b b a 2
x b a 3

Is this possible?

 

[David McRitchie]

Hi Cel,
I believe you meant sorted on the last *column*,
and according to the title in the worksheet instead of a User Form.

select the entire range to be involved, usually
you just select the entire sheet ctrl+A

You can do it this way,
select any cell in in Column D, then Ctrl+A
then Data, Sort, column D ascending, no headers