Convert Excel file for MYOB to import

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

When taking customer orders, I use an Excel spread sheet.

Customer names are in the columns

Items are in the rows.

When entering these orders into MYOB it is done manually by copying and pasting the item codes into MYOB and typing the quantity.

I am seeking a developer to create a program that will look at my excel sheet and translate it into a file that can be imported into MYOB.

One of the difficulties will be equating the customer name in the original spreadsheet to correspond with the customer name (and details) on the import sheet. We should discuss more and your solution is welcome.

I will provide example files:

- The original spreadsheet

Vs.

- How it should look when formatted correctly for import

Excel MYOB Software Development

Project ID: #13888139

About the project

16 proposals Remote project Active 7 years ago

Awarded to:

P0L

Hello, I’m an Excel/VBA developer and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$350 AUD in 5 days
(153 Reviews)
6.5

16 freelancers are bidding on average $355 for this job

cgullapalli

Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra

$250 AUD in 2 days
(466 Reviews)
7.4
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$250 AUD in 3 days
(167 Reviews)
6.6
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$750 AUD in 7 days
(153 Reviews)
6.7
caabdul

Hi, I have good experience with excel and MYOB. Let me see if I can help you. Thanks

$250 AUD in 3 days
(41 Reviews)
5.5
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and More

$555 AUD in 10 days
(38 Reviews)
5.5
arcdevsol

Hi there, I can write a program to convert excel file to myob format - Could you please show me a sample excel file and its corresponding myob format file? Thanks!

$277 AUD in 3 days
(5 Reviews)
5.1
surekash7096

I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.

$277 AUD in 5 days
(65 Reviews)
5.2
HawkGuyIA

I can foresee a couple different options. First, a macro to take your order form and create the necessary layout to save as CSV for import. Or, a web-based solution where you upload your file and it does the formatting More

$280 AUD in 2 days
(1 Review)
3.0
madhurna

Greetings! I am qualified accountant with nine years of experience in accounting. Please PM me to discuss further. Thank you.

$375 AUD in 3 days
(4 Reviews)
2.8
ZhangDa

Hi, A windows program may help. The program could do below. * Check all columns in original Excel files. * Check all columns in the new Excel files. * Then we see whether some columns could directly mapped. For e More

$300 AUD in 7 days
(1 Review)
1.9
ianoc

Hi! I would be glad to help you with this work and I am very confdient I can do a better job in this project than anybody else here. I understand you program that would convert your Excel files (formatted in a ce More

$250 AUD in 3 days
(0 Reviews)
0.0