Building a MACRO to AUTOMATE PROCESS

已关闭 已发布的 6 年前 货到付款
已关闭 货到付款

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 订单处理

项目ID: #16037064

关于项目

45个方案 远程项目 活跃的6 年前

有45名威客正在参与此工作的竞标,均价$127/小时

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 更多

$160 AUD 在3天内
(296条评论)
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 在3天内
(162条评论)
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 更多

$250 AUD 在3天内
(86条评论)
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 更多

$135 AUD 在3天内
(52条评论)
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 更多

$244 AUD 在5天内
(43条评论)
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 更多

$250 AUD 在3天内
(19条评论)
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 更多

$111 AUD 在2天内
(31条评论)
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 在3天内
(50条评论)
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 更多

$100AUD 在1天里
(14条评论)
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 更多

$100AUD 在1天里
(24条评论)
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 在5天内
(11条评论)
3.7
ongskjason

I will produce Excel with macro and VBA

$130 AUD 在2天内
(7条评论)
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 在3天内
(1条评论)
2.1
pcruiz

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

$200 AUD 在3天内
(2条评论)
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 在3天内
(0条评论)
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 更多

$80 AUD 在3天内
(0条评论)
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 在5天内
(0条评论)
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 更多

$155 AUD 在3天内
(0条评论)
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 更多

$30AUD 在1天里
(0条评论)
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 更多

$155 AUD 在2天内
(0条评论)
0.0