LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
boris
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating a dropdown list in excel Susan Excel Discussion (Misc queries) 2 January 14th 05 09:21 PM
Use dropdown list from Form Gerrym Excel Discussion (Misc queries) 1 January 4th 05 01:24 PM
How do I add a dropdown list in a spreadsheet? sidi New Users to Excel 1 December 29th 04 08:10 PM
how to increase the font size in a dropdown list? Sossys Excel Worksheet Functions 2 December 16th 04 01:09 PM
How do I set up a dropdown list in excel? The instructions given . Betsi Excel Worksheet Functions 1 November 8th 04 01:25 AM


All times are GMT +1. The time now is 06:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"