How to AUTO SORT A-Z new data in a column (not menual sorting)

[Nir]

In a table I wish to insert data to a certian column and than to have the
respected row sorted automatically accordingly.Meaning the whole table will
be sorted 1 column but automatically as I insert the data to the column.
Thanks

[Thiem]

Just record a macro, by highligting the whole colom, all of them you want to sort, then sort and stop recording macro

[RagDyer]

Post some examples of all the types of data that you're entering into this
column.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Nir" <[email protected]> wrote in message
news:[email protected]...
> In a table I wish to insert data to a certian column and than to have the
> respected row sorted automatically accordingly.Meaning the whole table
will
> be sorted 1 column but automatically as I insert the data to the column.
> Thanks