selective copy data from table
 

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-