Building a MACRO to AUTOMATE PROCESS

$30-250 AUD

Imefungwa

Imechapishwa

over 6 years ago

$30-250 AUD

Kulipwa wakati wa kufikishwa

We download a Sales Listing CSV File from EBAY for all sales made during the past day. This sales information then needs to be uploaded into our accounting software, however, due to system limitations, each sale within the sales listing spreadsheet needs to be: 1. Reformatted into a new Spreadsheet template with different titles; and 2. Each sales line requires a separate spreadsheet (e.g. if there were 10 sales, we would require 10 different spreadsheets with 1 order each) We would like to automate the above process with the click of a BUTTON, i.e. need your help performing a MACRO. Please see attached drafted overview of project that will need to be performed.

Kitambulisho cha mradi: 16037064

Kuhusu mradi

45 mapendekezo

Mradi wa mbali

Inatumika 6 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

45 wafanyakazi huru wana zabuni kwa wastani $127 AUD kwa kazi hii

@schoudhary1553

Greeting, I have understood your Building a MACRO to AUTOMATE PROCESS task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel, Excel Macros, Excel VBA, Order Processing

$160 AUD ndani ya siku 3

4.9

(296 hakiki)

7.8

@avinav606lx

Hi there, I can write the VBA script quickly. I'm an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks

$233 AUD ndani ya siku 3

4.9

(162 hakiki)

6.4

@DanielVizcaya91

Hi there. My name is Daniel and I would be glad to help you out with this project. I understand what you are looking for, however, I would appreciate if you could let me take a look at the original list file, plus the formatted one, as they were attached to the project. I can guarantee an excellent job and deliver as soon as possible.

$250 AUD ndani ya siku 3

4.7

(86 hakiki)

6.7

@vw7209238vw

Hi, I know what you are looking for exactly. I can get all rows information from csv, then parse in a master spreadsheet, then generate orders from each row in the master one. Each order in an individual spreadsheet. You didn't attach any file, please contact to chat about details you need in the orders. Please review my portrait and comments from my clients as a reference.

$135 AUD ndani ya siku 3

4.9

(52 hakiki)

5.6

@abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov

$244 AUD ndani ya siku 5

4.9

(43 hakiki)

5.2

@zu02

Hello, sir I saw your project and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. I am senior Access/SQL/VB /Excel developer since 1997 and I can write for you a user-friendly program using MS Excel . I am not engaged with any other project right now and I will work for 8 hours day for this Job. You can look into my portfolio here for my software screens for my previous work. Do revert me back if you feel like I am a suitable candidate for this Job and discuss further details. Thank You and Regards, Zura

$250 AUD ndani ya siku 3

4.7

(19 hakiki)

5.3

@jasalaz100

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.

$111 AUD ndani ya siku 2

4.9

(31 hakiki)

4.8

@teeares

This appears to be a simple project. Please provide the sales listing spreadsheet and a sample of the required spreadsheet.

$55 AUD ndani ya siku 3

4.5

(50 hakiki)

5.0

@rayyankabir

You need a tool to create spreadsheet for each order and the data should follow through the correct fields. I will integrate this process on one button. Also, I could give you a column mapping option between csv and template by which you can change the source and destination columns. I can deliver this today.

$100 AUD ndani ya siku 1

5.0

(14 hakiki)

4.6

@nelumindralal

Hello, I went thru the des. This can be done within today with 100% accurate. Kindly check my past job work I did similarly this kind of job Today can start. Looking forward to hearing from you Thanks Regards Thushara

$100 AUD ndani ya siku 1

5.0

(24 hakiki)

4.2

@iqmax99

Hello I can code the macro to take the downloaded data and re-format it as you wish. I can't do the load processing into your other system. Downloading the data from the web is also not possible. Regards.

$77 AUD ndani ya siku 5

5.0

(11 hakiki)

3.7

@ongskjason

I will produce Excel with macro and VBA

$130 AUD ndani ya siku 2

5.0

(7 hakiki)

3.8

@frankokucan

Please check my profile and send me details or example of how you want this to be done. This is some VBA programing and few macros. Best regards

$88 AUD ndani ya siku 3

5.0

(1 hakiki)

2.1

@pcruiz

I have more than 15 years of experience in developing solutions for excel using vba and/or excel formulas.

$200 AUD ndani ya siku 3

4.4

(2 hakiki)

2.0

@alinawaz1129

I am a data entry specialist in all Microsoft tools.I will do this work in less amount of money within the given period of time.

$35 AUD ndani ya siku 3

0.0

(0 hakiki)

0.0

@nickolajjessen

My current job's data is only available in (poorly constructed) CSV files, so i live and breathe in writing VBA to structure and consolidate databases from these. Writing VBA to your sales into seperate spreadsheets should be no problem.

$80 AUD ndani ya siku 3

0.0

(0 hakiki)

0.0

@odevw

I can automate your task based on your project specification. I'm an experienced macro developer and exposed to several Visual Basic Application projects.

$166 AUD ndani ya siku 5

0.0

(0 hakiki)

0.0

@Mannan1024

Dear Sir, I feel fit for your project. I have good skills of ms excel (macros, VBA, filtering, pivot table) email handling, web searching. I have 5 years experiences on those field in industry level. I have good skills in excel, excel VB, Visual Basic, access, swift data entry etc.

$155 AUD ndani ya siku 3

0.0

(0 hakiki)

0.0

@bhatakhilesh1991

I have 2+ years of experience in creating Macros using Excel VBA. I can understand any situation and determine how best we can leverage Macros to solve the particular problem. My proposal is : 1) Observe the data and understand its complexity. 2) Determine the degree of manipulation to be done on the data. 2) Build an appropriate, robust macro which reformats the data and solves the problem as per the requirements mentioned.

$30 AUD ndani ya siku 1

0.0

(0 hakiki)

0.0

@Nil1234

I have developed a lot of process like this. Actually this work can be done in a day, I have taken 1 more day as I need to SIT the tool. There are 2 approaches to automate this process one is front end approach and the other one is back end approach. Back end approach is strong and the solution will be the robust but if the back end id is not available then we will go for Front end approach for this process. I will prepare SDD (solution design document) and TDD ( Technical design document ) and as per the design we will build the flow. I hope you will give me the project not only get a good solution but to make a good professional relationship. Thanks Niladri

$155 AUD ndani ya siku 2