Macro for Excel (order sheet)

IN PROGRESS
Bids
14
Avg Bid (EUR)
33
Project Budget (EUR)
€30 - €40

Project Description:
Hi
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.

Skills required:
Excel, Visual Basic for Apps
Additional Files: OrderSheetWithoutData.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire dominique1
€ 40
in 1 days
Hire slavisatosic
€ 30
in 1 days
€ 40
in 1 days
€ 30
in 0 days
€ 40
in 1 days
€ 30
in 0 days
Hire crispymasala
€ 30
in 1 days
Hire ksnrajesh912
€ 30
in 1 days
Hire sthakral
€ 40
in 2 days
Hire VBA2013
€ 30
in 3 days