Macro for Excel (order sheet)
€30-40 EUR
Paid on delivery
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.
Project ID: #4176422
About the project
Awarded to:
12 freelancers are bidding on average €33 for this job
can implement the requirement of dependent combo-boxes and addition of line items etc. regards
I am able to fix the issue and implement the functionality as you require. Confidentially of data will be maintained at highest level.
Hello, I am an excel expert with advanced vba skills. I am looking forward to complete this task.