Results 1 to 3 of 3

Thread: excel - list appended to list

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2004
    Posts
    11

    excel - list appended to list

    The drop-down 1 selection should output a predefined list somewhere and drop-down 2 selection should append this list with the contents of another predefined list. For example:

    from drop down 1 I can select a, b or c. Selecting a gives me the list 1, 2, 3 selcting b gives me i, ii, iii and selecting c gives me I, II, III outputted somewhere in the same worksheet.

    then from drop-down 2 I can select x, y or z. Selecting x appends 99, 100, 101 to the end of the list I got from selecting something in drop down 1

    an example outout:
    1
    2
    3
    99
    100
    101

    but I need to be able to change the outputted lists. So for example selecting a from drop-down 1 gives me 1, 2, 3, 4 or just 1, 2

    I'm grateful for any help.

  2. #2
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: excel - list appended to list

    Drop down on a form or from a range of cells?

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

  3. #3

    Thread Starter
    New Member
    Join Date
    Nov 2004
    Posts
    11

    Re: excel - list appended to list

    from a range of cells

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width