M
my.wandering.mind
Hi All,
I have a table with 15 columns (a,b,c,d,e,f,g,h) and 500 rows. in this
table column d is the lowest level. there can be several instances of
the same record but with different column values
ex
a b c d e f g h
1 2 3 4 5 6 7 8
3 1 5 4 2 8 6 7
0 5 7 8 9 1 3 6
(value 6 in column f does not equal value 6 in column g.. every value
is unique)
I have created a listbox for user in a separate sheet which has all
the unique values of column d
When the user chooses from the list box I want some of the attributes
associated with it
ex
if user chooses 4 from listbox
then i want data in a separate row to display these columns
a b f d
1 2 6 4
3 1 8 4
Hope my explanation is clear
Could someone help me do this
Thanks for your help
v-
I have a table with 15 columns (a,b,c,d,e,f,g,h) and 500 rows. in this
table column d is the lowest level. there can be several instances of
the same record but with different column values
ex
a b c d e f g h
1 2 3 4 5 6 7 8
3 1 5 4 2 8 6 7
0 5 7 8 9 1 3 6
(value 6 in column f does not equal value 6 in column g.. every value
is unique)
I have created a listbox for user in a separate sheet which has all
the unique values of column d
When the user chooses from the list box I want some of the attributes
associated with it
ex
if user chooses 4 from listbox
then i want data in a separate row to display these columns
a b f d
1 2 6 4
3 1 8 4
Hope my explanation is clear
Could someone help me do this
Thanks for your help
v-