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.