Sorting Text Data

[Pritesh]

Hi,

I need to prepare a template where, user copies data in one sheet, out of
which in another sheet, I need a particular one column gets
automatically-sorted (without user using "Sort Function" alphabetically. Just
like using LARGE formula for digital data.

I am using Excel 2007. I am avoiding use of any Macros for this.

Pleasse help.


Regards,
Pritesh

 

[Dan DeHaven]

Hi,

I need to prepare a template where, user copies data in one sheet, out
of
which in another sheet, I need a particular one column gets
automatically-sorted (without user using "Sort Function"
alphabetically. Just
like using LARGE formula for digital data.

I am using Excel 2007. I am avoiding use of any Macros for this.

Pleasse help.


Regards,
Pritesh

I don't think that's possible without a macro/VBA. It wouldn't be a
hard macro to write and it could be triggered when the data range is
increased/pasted to.

Dan