Fermé

Macro for Excel

I need a macro written for an excel spreadsheet I use to generate picking lists for a fruit & veggie box delivery business. There are 8 different set fruit & veggie boxes that I set what is in them and then the customers also have the choice to pick what they like in the boxes.

There are three data sources (1) a spreadsheet which list what is in each of the 8 standard boxes; (2) spreadsheet with line list of the order number, customer's name, item description and quantity to be packed into the boxes; and (3) a spreadsheet with the customer's name, address and box number in order that they will be delivered.

The macro needs to (1) generate a report with the customer's name, size of box and box number {the size of box will be based on a range of criteria which will need to be incorporated into the macro such as number of items, size of items etc}; (2) generate a picking list that lists for each item (e.g. apple, orange, banana) the box number and the quantity of that item that goes in that box {this will include all the 8 standard boxes and the "pick your owns"}.

I will obviously need to explain in more detail once the bid is accepted however this gives you an idea of what is required.

Compétences : Excel, SQL

Voir plus : excel spreadsheet business, what is macro in excel, written list into excel, packed, macro, macro excel, macro e, macro + excel, excel to sql, Excel report, excel based, banana, range macro excel, excel report macro, macro spreadsheet, pick excel, macro report spreadsheet, order picking, macro report, macro address, excel address list, excel spreadsheet customer name address, excel macro address, business list excel, different address list excel

Concernant l'employeur :
( 1 commentaire ) Forrest, Australia

N° du projet : #1014577

25 freelance ont fait une offre moyenne de 69 $ pour ce travail

vbexcel

Excel/VBA expert.

90 $ AUD en 2 jours
(28 Commentaires)
5.5
DrTech76

Hi! Yes you sure have to explain it more "in real life", although I think it's not necessary that you wait until awarding the project. If you do this either in the description (you can do editions there) or on the "Cla Plus

40 $ AUD en 2 jours
(33 Commentaires)
4.9
telemarketing555

Hi. Please check your PM. Thank you.

100 $ AUD en 1 jour
(22 Commentaires)
4.4
oFAZo

Exceptional quality & Quick work. Please refer to Profile & Reviews for details. Thanks FAZ

90 $ AUD en 2 jours
(12 Commentaires)
4.4
muthumuni

Hi. I am expert for this job. Just have an look my review here. So kindly select me for get 100% satisfied your satisfaction is my success muthumuni

30 $ AUD en 1 jour
(7 Commentaires)
3.8
guevanjr

Quality and on-time delivery assured.

30 $ AUD en 1 jour
(5 Commentaires)
2.9
statnxt

Please refer to your Inbox for details and a proposal. Thanks!

100 $ AUD en 3 jours
(3 Commentaires)
2.2
emce75

Hi, if I understand right it shouldn't be a hard code however I'd like to see samples :) Regards.

60 $ AUD en 1 jour
(1 Commentaire)
1.8
siwakotisurya

ready to do this work

35 $ AUD en 2 jours
(0 Commentaires)
0.0
grpc12

Hi I am ready to start, let me show you what I can do. Please see PM

100 $ AUD en 3 jours
(0 Commentaires)
0.0
getdatajob

Please read the PM and I send you a sample file too

60 $ AUD en 4 jours
(0 Commentaires)
0.0
braindon

good day sir, i am interested with this job. eprovide me more details. thanks...

30 $ AUD en 1 jour
(0 Commentaires)
0.0
Perry78

Sir, please check my PM. Thanks

100 $ AUD en 7 jours
(1 Commentaire)
0.0
Rakeshkmrsharma

Hi Please check PM for Details.

35 $ AUD en 1 jour
(0 Commentaires)
1.9
cyadav

Hi, Please allocate this project to me for highest quality output. Please see the PM. Thank you.

100 $ AUD en 2 jours
(0 Commentaires)
0.0
lahongthang

Easy job! Let me do for you.

30 $ AUD en 1 jour
(0 Commentaires)
0.0
parthimoorthy

Lets start to work now

75 $ AUD en 2 jours
(0 Commentaires)
0.0
dhruvsg

I have experience in Excel and making macro and processing of large records and spreadsheets and having the knowledge of visual basic and database like access, i am doing the work as like

107 $ AUD en 2 jours
(0 Commentaires)
0.0
eric06201975

Please count me in ,give an excel and the output that you need. I will send the macro once i finished .., Im a vb programmer / vba and i know how to generate reports that you want..or bassically will create a program Plus

90 $ AUD en 2 jours
(0 Commentaires)
0.0
Lubabvblogic

Hello! Your offer is very interested for us. We know how to realize it and have an experience in development the same projects. The project will SQL database, it will be simple in support and develop. We also in Plus

100 $ AUD en 2 jours
(0 Commentaires)
0.0