In Progress

Macro for Excel (order sheet)

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: Excel, Visual Basic for Apps

See more: excel macro order, visual basic for applications, what is macro in excel, line sheet, excel visual basic, excel data sheet, excel 2013, order field, excel 2013 version, excel macro add, 2013 visual basic applications excel, text box excel, sheet excel visual basic, 2013 excel visual basic, excel 2013 visual, excel 2013 macro, excel macro send email, macro send email, excel text column, add excel macro, send email macro excel, visual basic excel 2013, macro send email excel, email excel data sheet, excel 2013 visual basic applications

About the Employer:
( 14 reviews ) Vitoria, Spain

Project ID: #4176422

Awarded to:

slavisatosic

Hello, I am offering to make you these VBA macros by tomorrow.

€30 EUR in 1 day
(54 Reviews)
5.1

13 freelancers are bidding on average €33 for this job

dominique1

No problem, I can fix the macros.

€40 EUR in 1 day
(86 Reviews)
5.2
VBAWhizz

Hi, I can do this easily.

€40 EUR in 1 day
(4 Reviews)
4.3
nayabsiddiqi

can implement the requirement of dependent combo-boxes and addition of line items etc. regards

€30 EUR in 0 days
(6 Reviews)
3.7
customizedata

I have gone through the attached [url removed, login to view] have a look at private message for my queries.

€40 EUR in 1 day
(11 Reviews)
3.7
cosconeaionut

I know to fix it. See pm. Quality and fast.

€30 EUR in 0 days
(6 Reviews)
3.6
crispymasala

I am able to fix the issue and implement the functionality as you require. Confidentially of data will be maintained at highest level.

€30 EUR in 1 day
(8 Reviews)
3.3
ksnrajesh912

Hello please check your PM

€30 EUR in 1 day
(4 Reviews)
2.8
sthakral

Your macro is ready and error free. Please check PMB

€40 EUR in 2 days
(1 Review)
1.9
Baponbaidyaarup

please check my pm

€30 EUR in 5 days
(0 Reviews)
0.0
NayakKedar

HI i work for an MNC in Automation..I can easily do this project....

€30 EUR in 1 day
(0 Reviews)
0.0
Tina0603

Hello, I am an excel expert with advanced vba skills. I am looking forward to complete this task.

€30 EUR in 3 days
(0 Reviews)
0.0
Geron

The VBA script in your file can be optimised. The bug with the 2nd combo box is very simple. See PMB for details, please.

€30 EUR in 0 days
(0 Reviews)
0.0
VBA2013

I have big experiance of excel and VBA. please give me one chance.

€30 EUR in 3 days
(0 Reviews)
0.0