Hi all,
Im using excel 2010 with windows 7.
I need help with a sheet that I made that is going to be used as an ordering tool for customers. It's very basic; all the possible items that can be ordered are in a searchable drop down list that I made using the combo box and a macro that I found here: How to create a searchable drop down list in Excel? . The drop down list works really well but my problem is that the customer can order any number of items from the list.
I need help with making it so that once they select an item from the drop down list, another drop down list will appear in the cell underneath with the exact same choices, and that needs to continue technically infinitely.
Im using excel 2010 with windows 7.
I need help with a sheet that I made that is going to be used as an ordering tool for customers. It's very basic; all the possible items that can be ordered are in a searchable drop down list that I made using the combo box and a macro that I found here: How to create a searchable drop down list in Excel? . The drop down list works really well but my problem is that the customer can order any number of items from the list.
I need help with making it so that once they select an item from the drop down list, another drop down list will appear in the cell underneath with the exact same choices, and that needs to continue technically infinitely.
