|
-
Apr 27th, 2005, 06:27 AM
#1
Thread Starter
New Member
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.
-
Apr 28th, 2005, 07:40 AM
#2
Re: excel - list appended to list
Drop down on a form or from a range of cells?
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...
-
Apr 29th, 2005, 05:52 AM
#3
Thread Starter
New Member
Re: excel - list appended to list
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|