| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
make column lists for select query.
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
make column lists for select query.
I think you may want some dependent lists.
http://www.contextures.com/xlDataVal02.html HTH, Barb Reinhardt "kang" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SELECT Query | Excel Worksheet Functions | |||
| How to select group of drop down lists to align | New Users to Excel | |||
| Excel query about Lists | Excel Worksheet Functions | |||
| Drop down lists - thanks (and one more query) | Excel Worksheet Functions | |||
| Drop down lists - thanks (and one more query) | Excel Discussion (Misc queries) | |||
Linear Mode
