Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
import specific fields only from excel to database | Excel Discussion (Misc queries) | |||
Desktop Shortcut to Specific Sheet in Excel | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) |