Very easy task, but I'm not able to do! :-(( We have an order sheet with 2 comboBox, first comboBox is to choose category of product (is implemented). When you choose the category, the second ComboBox, must get the data of the selected Category, going to the Sheet with the name of the category and getting all the fields in the first column (implemented but with ERRORS).
Finally, the user selects one product and inserts a quantity in the field Quantity, after that he has to click "Añadir/Add" button and Excel has to add a line of order, with the quantity in the text box and some data from the PriceListSheet of this category.
I've uploaded a reduced version of the file, so you can get an idea of what I want. In addition I can send the file by email, but confidentiality is required, because is data from the company.