Building a MACRO to AUTOMATE PROCESS

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

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.

Excel Excel Macros Excel VBA Order Processing

Project ID: #16037064

About the project

45 proposals Remote project Active 6 years ago

45 freelancers are bidding on average $127 for this job

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 M More

$160 AUD in 3 days
(296 Reviews)
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 in 3 days
(162 Reviews)
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 More

$250 AUD in 3 days
(86 Reviews)
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. Y More

$135 AUD in 3 days
(52 Reviews)
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 Applicat More

$244 AUD in 5 days
(43 Reviews)
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 de More

$250 AUD in 3 days
(19 Reviews)
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 an More

$111 AUD in 2 days
(31 Reviews)
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 in 3 days
(50 Reviews)
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 te More

$100 AUD in 1 day
(14 Reviews)
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 More

$100 AUD in 1 day
(24 Reviews)
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 in 5 days
(11 Reviews)
3.7
ongskjason

I will produce Excel with macro and VBA

$130 AUD in 2 days
(7 Reviews)
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 in 3 days
(1 Review)
2.1
pcruiz

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

$200 AUD in 3 days
(2 Reviews)
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 in 3 days
(0 Reviews)
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 sh More

$80 AUD in 3 days
(0 Reviews)
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 in 5 days
(0 Reviews)
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 s More

$155 AUD in 3 days
(0 Reviews)
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 a More

$30 AUD in 1 day
(0 Reviews)
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 More

$155 AUD in 2 days
(0 Reviews)
0.0