Sorting Text Data

P

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
 
D

Dan DeHaven

Pritesh;479250 said:
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
Click to expand...

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
 
Top