Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically extend a list when adding a new data to another list
Hi,
I could not find the solution to my problem in the questions asked so here we go: I have two lists, color and type: Color: Red, Blue, Green Type: A, B, C From this I would like to create a third list showing me all combinations of "color" and "type" (eg. RedA, RedB... =[color]&[type]). I want the third list to be extended whenever I add a value to any of the first two lists. Is this possible ? If yes, how? Thanks in advance! //Johan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
produce list automatically from choice of drop down list | Excel Discussion (Misc queries) | |||
Automatically adding a row to a list | Excel Discussion (Misc queries) | |||
how can I extend my drop-down box length to include all the list? | Excel Discussion (Misc queries) | |||
How to extend the no' of displayed entries in a drop down list | Excel Discussion (Misc queries) | |||
how to extend data to next sheet automatically during sql query | Excel Discussion (Misc queries) |