Đã Đóng

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.

Kỹ năng: Excel, SQL

Xem thêm: excel spreadsheet business, written list excel, packed, macro, macro excel, macro e, 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 macro address, business list excel, different address list excel, macro excel report, generate report excel, excel business, excel macro data list

Về Bên Thuê:
( 1 nhận xét ) Forrest, Australia

Mã Dự Án: #1014577

25 freelancer đang chào giá trung bình $69 cho công việc này

vbexcel

Excel/VBA expert.

$90 AUD trong 2 ngày
(28 Đánh Giá)
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 Thêm

$40 AUD trong 2 ngày
(33 Đánh Giá)
4.9
telemarketing555

Hi. Please check your PM. Thank you.

$100 AUD trong 1 ngày
(22 Đánh Giá)
4.4
oFAZo

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

$90 AUD trong 2 ngày
(12 Đánh Giá)
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 trong 1 ngày
(7 Đánh Giá)
3.8
guevanjr

Quality and on-time delivery assured.

$30 AUD trong 1 ngày
(5 Đánh Giá)
2.9
statnxt

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

$100 AUD trong 3 ngày
(3 Đánh Giá)
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 trong 1 ngày
(1 Đánh Giá)
1.8
siwakotisurya

ready to do this work

$35 AUD trong 2 ngày
(0 Đánh Giá)
0.0
grpc12

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

$100 AUD trong 3 ngày
(0 Đánh Giá)
0.0
getdatajob

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

$60 AUD trong 4 ngày
(0 Đánh Giá)
0.0
braindon

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

$30 AUD trong 1 ngày
(0 Đánh Giá)
0.0
Perry78

Sir, please check my PM. Thanks

$100 AUD trong 7 ngày
(1 Đánh Giá)
0.0
Rakeshkmrsharma

Hi Please check PM for Details.

$35 AUD trong 1 ngày
(0 Đánh Giá)
1.9
cyadav

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

$100 AUD trong 2 ngày
(0 Đánh Giá)
0.0
lahongthang

Easy job! Let me do for you.

$30 AUD trong 1 ngày
(0 Đánh Giá)
0.0
parthimoorthy

Lets start to work now

$75 AUD trong 2 ngày
(0 Đánh Giá)
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 trong 2 ngày
(0 Đánh Giá)
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 Thêm

$90 AUD trong 2 ngày
(0 Đánh Giá)
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 Thêm

$100 AUD trong 2 ngày
(0 Đánh Giá)
0.0