self-building dropdown list

would like to have a sheet where one of the columns has
cells which are a self-building list. I understand the
need to have any formula or validation copied into the
new line that is entered (which would be the one that
needs the previous entries' listings in its list). I
will accomplish this by requiring that any new line entry
be made with a macro to copy over the formatting and all
of the previous line. Need the logic of how to get this
self-building list to work. I was thinking of it in
validation dropdown terms, but 1) don't know how to do it
that way, and 2) thought there may be some other way of
which I am unaware. Would obviously like the list to
only list entries once.

Thanks for any help.

Boris

Perhaps a peek at Debra Dalgleish's nice coverage of dynamic* ranges
would be fruitful:
http://www.contextures.com/xlNames01.html#Dynamic

*self-building lists are usually dynamic lists
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik atyahoodotcom
----
boris wrote in message
...
would like to have a sheet where one of the columns has
cells which are a self-building list. I understand the
need to have any formula or validation copied into the
new line that is entered (which would be the one that
needs the previous entries' listings in its list). I
will accomplish this by requiring that any new line entry
be made with a macro to copy over the formatting and all
of the previous line. Need the logic of how to get this
self-building list to work. I was thinking of it in
validation dropdown terms, but 1) don't know how to do it
that way, and 2) thought there may be some other way of
which I am unaware. Would obviously like the list to
only list entries once.

Thanks for any help.

Boris