Hello!
Let me start off by giving you an idea of what I’ve been working on. I’ve been making dependant drop down lists in excel from right to left using data validation. For example in the far left cell you click and select a manufacturer (ie Case Internation or Bobcat), then in the next drop down list you choose a model (ie 400-Series SSL or M-Series Loader/Backhoe) then the next drop down will give you the base prep time for that machine ( I have not figured out how to just pull a number and display it from the data sheet. I’ve just been using the drop-down because that’s all i’ve been able to figure out. So when you pull down that drop down there is only one selection possible), then to the right of that is a series of drop down lists stacked on top of one another (about ten or so) where you can select various implements that are to go on that machine (ie Block Heater, Air Conditioning, Radio, etc) each with another drop down list to the right of them displaying additional prep time (again using drop downs to pull the values and display them). WOO! Anyway, sometimes when when selecting implements all of them won’t list in the drop-down. For example if I choose Case International in the far left, then M-Series Loader/Backhoe in the model drop down, then go to select the implements and not all are shown. On my data sheet I have made sure that M-Series Loader/Backhoe is typed the same in every cell with each implement for that unit listed directly to the left. Something like this…
Model | Implement |PrepTim
M-Series Loader/Backhoe | Block Heater | 3
M-Series Loader/Backhoe | Radio | 6
M-Series Loader/Backhoe | Air Cond. | 20
you get the point. Do you think that the reason that all implements are not listed because all of the models are stacked on top of each other? Is there some sort of limit to the data you can have in a sheet? My sheet doesn’t exceed 125 lines (so far) and it’s still giving me issues. Is there a better way to make a “prep time calculator” in excel? Are there any helpful aspects to VBA in excel that would be beneficial? I’ve made a CommandButton1 that clears all of the selections after you have finished so you can start over. Other than that I haven’t messed with VBA much. Could I utilize IF functions to help solve my problem? I’ve been using OFFSET and data validation to pull my data…is that what’s causing my issue? PLEASE HELP! =)
THANKS sO MUCH!
