mitcho_uk
Member
Hi all,
My boss is an arse and when he gets something into his head thats what you have to create no matter how difficult or on numerous occassions, impossible it is to achieve. Therefore i have a problem with which somebody may be able to help.
He wants me to create a form using excel so that our sales reps can send in quotation requests to the admin staff. I have created a basic form that allows the rep to select the relevant data and paste it into the form, it is easy and it works. However he wants to use a drop down list (we have 1800 products) I can create a filter which will do this easily enough but that will only let them select one product. He seems to think that you can have numerous drop down menus, one under another to select numerous products, however I cannot figure out how to do this, I have searched on the web but I have not seen anything like it.
Any ideas?
My boss is an arse and when he gets something into his head thats what you have to create no matter how difficult or on numerous occassions, impossible it is to achieve. Therefore i have a problem with which somebody may be able to help.
He wants me to create a form using excel so that our sales reps can send in quotation requests to the admin staff. I have created a basic form that allows the rep to select the relevant data and paste it into the form, it is easy and it works. However he wants to use a drop down list (we have 1800 products) I can create a filter which will do this easily enough but that will only let them select one product. He seems to think that you can have numerous drop down menus, one under another to select numerous products, however I cannot figure out how to do this, I have searched on the web but I have not seen anything like it.
Any ideas?