make column lists for select query.

  • Thread starter Thread starter kang
  • Start date Start date
K

kang

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.
 
Back
Top