Devam Ediyor

20100520 Excel Macro VBA order spreadsheet

Excel VBA programmer to design a VERY simple order tracking dispatch system. I already have a spreadsheet system with some macros but it is a little complicated and time consuming to use. A VBA system will work much better.

Here’s my process which needs a system:

[url removed, login to view] downloading a CSV file of orders, I separate name fields using macro. Sometimes there are too many names in name fields which cause the macro to stop. I think adding a middlename field will solve this.

[url removed, login to view] this file into a master list of orders

[url removed, login to view] off payments and check payments

[url removed, login to view] 2 dispatch lists from paid but not shipped orders. One dispatch list is formatted one way and needs to be emailed in CSV format to the shipping company. The other dispatch list is formatted another way and printed. The latter is for orders that are packed onsite.

[url removed, login to view] orders have been dispatched, mark them off as dispatched.

[url removed, login to view] orders to check which are paid and which aren’t.

I need to streamline the process and use VBA/Macros to make this task easier and simple.

I’ll show the winner step by step what I currently do so you can understand the process and create the spreadsheet from there.

Payment: Escrow

Timeframe: 1 day

Beceriler: Excel, Visual Basic

Daha fazlasını görün: excel macro order, dispatch order excel format, vba work, vba with, vba excel programmer, streamline design, programmer spreadsheet, programmer excel vba, printed names, payment system escrow, master excel 2010, mark fields, programmer names, excel macros need programmer, escrow payments company, order dispatch excel format, macro orders excel, vba time, vba for, in vba, excel mark, csv spreadsheet, master excel, excel spreadsheet programmer, escrow shipping company

İşveren Hakkında:
( 36 değerlendirme ) Baulkham H, Australia

Proje NO: #691196

Seçilen:

sTdwares

Hello. PLease check your PMB before you make a decision. Regards.

1 gün içinde 60$ USD
(1 Değerlendirme)
1.6

25 freelancer bu iş için ortalamada 81$ teklif veriyor

MAnkita

Hello,Please refer your PMB.Thank you.

in 2 gün içinde150$ USD
(76 Değerlendirme)
6.1
koolsidz

Please see PMB

1 gün içinde 100$ USD
(100 Değerlendirme)
5.8
mrbrave

Ready to start now....

1 gün içinde 80$ USD
(80 Değerlendirme)
5.4
agihcam

Please check PMB.

1 gün içinde 80$ USD
(38 Değerlendirme)
5.2
SergeyPlus

Hello. I am very good at math and excel so can do your project easily . Sergey S.

1 gün içinde 120$ USD
(13 Değerlendirme)
4.5
SmartGuru

Hello, I have worked on many Excel VBA projects and would be glad to take up your project as well. Hoping to hear a positive reply from your part. Kind regards.

1 gün içinde 55$ USD
(14 Değerlendirme)
4.4
himanshuhc

Hi, ready to start right away and will deliver within 24 hours. Please refer PMB for sample work and details.

1 gün içinde 30$ USD
(14 Değerlendirme)
4.4
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

1 gün içinde 35$ USD
(15 Değerlendirme)
4.4
freddyho

Please see your PMB

1 gün içinde 50$ USD
(7 Değerlendirme)
4.0
zszabo

Hi, Please see PM. B.R. Zoltan

in 3 gün içinde100$ USD
(3 Değerlendirme)
2.2
setsailgo

Dear sir: I can do this for you ASAP.thanks!

1 gün içinde 100$ USD
(1 Değerlendirme)
2.0
neelu7779

hi, Please check PMB for sample work. You will definitely like it.

1 gün içinde 80$ USD
(2 Değerlendirme)
2.0
sayli2

very simple for me.please check PMB

in 3 gün içinde50$ USD
(2 Değerlendirme)
1.6
indivar

Hi, Kindly read PM for details of proposal Inderjeet Singh

1 gün içinde 100$ USD
(1 Değerlendirme)
1.1
Jia21

Well, this kind of project should be done in MS Access. There will be a lot more flexible and can provide more function. You might not even to write a single line of code to do what you want to achieve.

1 gün içinde 50$ USD
(1 Değerlendirme)
1.0
rodolforamirez

Hi!!, I am ready to start your project as soon I get details.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
kammy786

i am a good worker and i will returned the project on time.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
jotaudos

Provide further info. I will deliver!

in 10 gün içinde240$ USD
(0 Değerlendirme)
0.0
sheetalraut

Hi, with ur help can be finish earlier.

in 7 gün içinde100$ USD
(0 Değerlendirme)
0.0
pareekravi

I am ready to do this project as stated in your terms. PLease let me know when I shall start

1 gün içinde 100$ USD
(0 Değerlendirme)
0.0