Posted: 6/9/2008 5:26:09 PM EDT
|
Got a question for you guys that are good with Excel. I'm making up a reloading spreadsheet, and want to use some dropdown lists. I know how to make the lists, but I would like to link them together and don't know how to do that, or if it's possible. For example. I have a Powder section. Under Manufacturer I have a drop down list with the powder makers. I want to link it so that if I pick Hodgdon from the manufacturer list, then in the type column it will show H335, BLC-(2), Varget, etc. in the type dropdown list. But if I pick Alliant then it will show Alliant powders in the type list. And so on and so forth. So the options change depending on what you choose in the original list. Is this possible to do? And how would I go about doing it? Thanks |
|
If you have excel you should have access and it would be much easier in there. In excel you would have to have another sheet with all the names of the different powders and in another column the brand of the powder. Try the vlookup function. But the thing is I am not sure how you are going to get the other rows without doing it in a loop. You will have to make a macro to execute it several times and all that. It is pretty hard to make excel act like SQL |