Write Excel Macro

$10-30 AUD

Dalam Kemajuan

Disiarkan

hampir 7 tahun yang lalu

$10-30 AUD

Dibayar semasa penghantaran

I export a report out of MYOB that comes out as a tab-delimited text file. It contains jobs assigned to each staff member grouped by customer. I would like an excel macro that will read this exported file and generate an Excel file with 3 sheets (sample is provided and details given below): 1. Master sheet (all jobs and columns, sorted by promised date) 2. Jon Warehouse (specific jobs and columns) 3. Jonathan Workshop (specific jobs and columns) Description of attached files: 1. data [login to view URL] what we get out of MYOB in need of a macro 2. zoho [login to view URL] contains RAW DATA from above text, column name conversions and examples of the last 2 sheets. I've tried to format an example line so you can get an idea of what we need. I would also like some graphs created that give visual job summary. This can be discussed later.

Coding

Excel

ID Projek: 13915696

Tentang projek

22 cadangan

Projek jarak jauh

Aktif 7 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

22 pekerja bebas membida secara purata $31 AUD untuk pekerjaan ini

@sorinacho88

You need to ask a question that you need to develop solution for this specific data and needs Hello, I have understood the requirements and it's clear to me. There will be an Excel template with a button the select the raw file from the MYOB app. The data will be imported (and cleaned) into a hidden sheet. From this sheet, the macro will populate the other 3 sheets. Proposal: Hello, If you are interested please open a chat with me. Kind regards, Sorin

$60 AUD dalam 3 hari

5.0

(67 ulasan)

5.5

@ketas

You need to ask a question that you need to develop solution for this specific data and needs Is the template of the output fixed or not ? If this template is not change , I could finish this tool in a very short time Proposal: Many experience with VBA on MS Excel .Since I'm new freelancer, I'm willing do it for you with a very low cost !

$24 AUD dalam 0 hari

4.6

(13 ulasan)

3.9

@only1ls

You need to ask a question that you need to develop solution for this specific data and needs Did you want to introduce a graph to show an output level or anything? Does the layout have to stay the same as your example? Proposal: I have Advanced Excel & VBA skills so I can help you with your project. Please message me to discuss in more detail. Thank you

$30 AUD dalam 2 hari

4.9

(4 ulasan)

3.5

@huongth

You need to ask a question that you need to develop solution for this specific data and needs cant do this project within $30 Proposal: Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now

$100 AUD dalam 3 hari

4.3

(11 ulasan)

3.5

@gabi19

You need to ask a question that you need to develop solution for this specific data and needs no, not need to ask something and suppose that the files attached contains only dates that can be read Proposal: dear freelancer i have some macro for different purposes, so if you want I can try to write for you a project in this question regards

$25 AUD dalam 1 hari

5.0

(2 ulasan)

1.2

@nworldsheila

You need to ask a question that you need to develop solution for this specific data and needs Which statistical techniques do you want to apply? Proposal: I am the best candidate for this project coz I have the ability to work as a team well and completed the project.

$25 AUD dalam 1 hari

0.0

(0 ulasan)

0.0

@Mindalin

Hello. I constantly work with the technologies specified in the job description. I need more information, but in any case, working for me is not a problem.

$18 AUD dalam 3 hari

0.0

(0 ulasan)

0.0

@pathumganegoda

i am working in a leading private bank and have done many similar projects. therefore i can deliver what you wish

$17 AUD dalam 2 hari

0.0

(0 ulasan)

0.0

@brulzjack

I basically work on automating excel based tasks by writing Vba code, daily.

$11 AUD dalam 1 hari

0.0

(0 ulasan)

0.0

@CholoGinga

i have a lot of experience with this type of job. hope you give me an opportunity to handle this task. thank you

$15 AUD dalam 0 hari

0.0

(0 ulasan)

0.0

@mayramo

Hi: I can help you with this job, i have been workin for 8 year in this kind of work Please let me know if you are interested in my serveces. Mayra Alejandra Morales .

$35 AUD dalam 1 hari

0.0

(0 ulasan)

0.0

@tylercoppinger

You need to ask a question that you need to develop solution for this specific data and needs How are you differentiating between what is in 'Jons Warehouse' and what is in 'Jonathan Workshop'? Also, my bid is over the max budget but I feel that it is warranted in this case because you are asking for a significant macro that requires entire spreadsheet design. Proposal: Finance professional who lives in Excel/VBA and makes a career off quality spreadsheet design and manipulation. Available via chat or cell phone with any questions/concerns.

$55 AUD dalam 1 hari