Macro for Excel (order sheet)

This project was awarded to slavisatosic for €30 EUR.

Get free quotes for a project like this
Project Budget
€30 - €40 EUR
Total Bids
Project Description


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.

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online