sheet1
table1 col1_1
table1 col1_2
table1 col1_3
table1 col1_4
table1 col1_5
table1 col1_6
table2 col2_1
table2 col2_2
table2 col2_3
table2 col2_4
...
...
sheet2
table1 col1_1,col1_2,col1_3,col1_4,col1_5,col1_6,
table2 col2_1,col2_2,col2_3,col2_4,
...
...
I want to make column lists for some table listed in sheet1.
for example, select column_lists from table1
without vba is it possible?
thanks.
Barb Reinhardt - 16 Jul 2007 13:32 GMT
I think you may want some dependent lists.
http://www.contextures.com/xlDataVal02.html
HTH,
Barb Reinhardt
> sheet1
> table1 col1_1
[quoted text clipped - 22 lines]
>
> thanks.