Simple VBA with just 1 button.

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

1) 2 Order above with different customers name with the same time zone = 0.7 points for the trip number.

2) Having the same postal code with 2 customers and 1 of the customers ordered twice, however the time zone is different, therefore each is being awarded with 1 point each

3) Having the same postal code with different customer which means that each is rewarded with 1 point. If there is more than 2 orders at the same postal code, refer back to criteria 1.

4) Having the same postal code and same customer name, however the instructions is written as "Click and Collect". The points should be awarded with this login (1,0,0)(1,0,0)(1,0,0). If they have 5 orders the points should be (1,0,0,1,0). Means that the loops is repeating.

5) Having the same postal code and same customer name, however the instructions is written as "VWO". No matter how many orders they had under the same customer name and same postal code, only 1 points is rewarded.

6) Having same postal code but quantity is more than 35 quantity in a single order is rewarded with 2 points.

7) Having same postal code but quantity is more than 46 quantity in a single order is rewarded with 3 points.

Powershell Software Architecture Software Development VB.NET Visual Basic

Project ID: #15364401

About the project

3 proposals Remote project Active 6 years ago

Awarded to:

infoistic

Hi, just a job of few hours, can you send the excel file, so that I can send a demo. I can make the excel, just saving some time. Thanks

$30 SGD in 1 day
(5 Reviews)
2.1

3 freelancers are bidding on average $26 for this job

NavrozPatel

Hello Sir. I have 5+ years experience in VBA. I can do this project very easily without any issue and in no time. Just message me so that we can start this project right now. Relevant Skills and Experience VBA Propos More

$22 SGD in 1 day
(0 Reviews)
0.0