I need some advice on how to create a BOM form based on list box choices made.
Attached is a blank form i have created that i want bill of materials dropped into.
I was thinking of using dependent list boxes to choose what i want.
Example:
User will choose a base model home in first list box. Then second box with have a list of elevations based on list box one. Then third will have a list all options available for that model home and elevation. If it is possible i would like the third box to allow several selections to be made. If not i will have to make more list boxes for any extra options chosen. Beyond the 2nd list box nothing will be dependent on the previous one.
Now after those choices are made, or even as i am selecting them, i would like data from a range in another workbook to be copied into this blank form. I have one workbook that has all base model homes on individual tabs and then i have a workbook for each model home options with each option on a tab. After each copy i guess it would have to copy data on next available empty row and if i run out of empty rows in the range add new ones in the body of the form. If i can get to a starting point i can add the data needed if someone can help.
Am i asking more out of excel than possible?
Thank you,
Bookmarks