View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
Ratedr Ratedr is offline
external usenet poster
 
Posts: 8
Default Database (or the like) from Excel Sheet

I have an excel sheet that looks like the following

style weight1 weight2
x 1.5 2.5
y 1.7 2.9
z 2 3.1

and so on (except that my database has over 1000 styles with weights,
etc) What I want to do is build a simple database that when I search
for y, for example, it will return to me the weight 1 and weight 2
result. For example it would have a line that says... Style? ____
and I put in y and then it says weight1=x
weight2=y

OR, I could have a dropdown menu that has all of the styles in it and
when I select the style I wanted, it displays the weights 1 and 2....or
anything like that. Can anyone help me with starting that and also
maybe if you have a better idea of what to do, it would be appreciated