Building a MACRO to AUTOMATE PROCESS
$30-250 AUD
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.
Project ID: #16037064
About the project
45 freelancers are bidding on average $127 for this job
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
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
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
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
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
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
This appears to be a simple project. Please provide the sales listing spreadsheet and a sample of the required spreadsheet.
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
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
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.
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
I have more than 15 years of experience in developing solutions for excel using vba and/or excel formulas.
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.
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
I can automate your task based on your project specification. I'm an experienced macro developer and exposed to several Visual Basic Application projects.
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
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