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

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

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

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" <Nir@discussions.microsoft.com> wrote in message
news:EC888C36-8473-4979-A64D-D4B4C3C098D0@microsoft.com...
> 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