VBA Developer for Data Extraction, Sort and Formatting Project


I would like to be able to complete the following project by the 8th July 2018.

I will download a report daily as an xml file that will be saved with the same name. There will be two reports in total (both in the same format with the same headers), one for each location. All the below will need to be completed so that we can analyse the data for each location and the combined data for both locations.

The structure of the data will be:

• Parent – Category Type

• Child 1 – Category

• Child 2 – Product

• Child 3 – Modifiers

*All the above will then have a variety of data associated with it including Volume, Tax, Time Stamp etc.


A macro will be needed to perform the following:

1. Open a daily XML file as mentioned above (this will be in a standard format with varying data).

2. Correlate a small amount of the data against a reference sheet (in a separate .xls file) to add in an extra column to the raw data.

- All sale items have a “Category” attached to them in the xml file, we will need to attach a “Category Type” to all the categories also allowing for any new categories/Category Types being added into the reference sheet (If there is no corresponding “Category Type” in the reference sheet it should default to a “Category Type of “Uncategorised”.

3. Sort, filter and extract relevant data (indicated in the attached file “XML Map [login to view URL]”)

- This will includes splitting the Product to show the modifiers (these are separated by a “+” and I have given an example in the attached file “Product Modifier [login to view URL]”

4. Produce a Daily report, with calculations, to measure selected KPIs

5. Combine the daily reports into a weekly summary

6. Create a spreadsheet that will track the weekly trends and predict the following weeks sales

7. Automate the import, sort and exporting of both daily report, weekly summary report and running trend and predictions report via a Task Scheduler VBS Script

8. Be able to pull in historic reports for back dated data


All steps to be tested and should account for error handling in the raw data.

There should be a file path line in the final spreadsheet which will be used to export the reports to.

I am happy to answer any questions and will be available for roughly 1-2 hours per day to work with you on this project.

Skills: Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps

See more: functional specification project overview, visual basic data grid sort, data mining online poker project, how to sort data in excel 2010 using vba, sort numbers vba, sort worksheet vba, how to sort data in pivot table vba, how to do sorting in vba, vba code for sorting data in excel, sort with headers vba, sort special vba, data entry, software development, data processing, software architecture, excel, visual basic, visual basic for apps, microsoft excel, data list sort

About the Employer:
( 2 reviews ) London, United Kingdom

Project ID: #17225185

42 freelancers are bidding on average £509 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

£611 GBP in 4 days
(697 Reviews)

Hello, I can help with you in your project VBA Developer for Data Extraction, Sort and Formatting Project. I have more than 5 years of experience in Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for App More

£500 GBP in 5 days
(327 Reviews)

HI, I am good at Excel and VBA. I have reviewed the requirements in brief. Looking forward to discuss in details with the excel files provided. I can contribute 2 hours daily on this and discuss on the requiremen More

£1000 GBP in 20 days
(851 Reviews)

Hello! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention Excel because this is my favorite field and Excel projects are among tasks I work with regular More

£450 GBP in 7 days
(201 Reviews)

I read your requirements carefully and I confirm that I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data import from other Excel files a More

£500 GBP in 7 days
(199 Reviews)

Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within th More

£444 GBP in 5 days
(108 Reviews)

Dear Employer, I'm ready to work on "vba developer for data extraction, sort and formatting project" project. I have 5 years experience in Visual Basic, Excel, Visual Basic for Apps. 1500 GBP - proposed project bu More

£1500 GBP in 30 days
(123 Reviews)

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

£555 GBP in 10 days
(99 Reviews)

I am proficient with excel macro/VBA , I've gone through the attached files, I can write the macro to convert XML report into excel for daily report as specified in your description, I am available to start your projec More

£450 GBP in 10 days
(77 Reviews)

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

£432 GBP in 10 days
(68 Reviews)

- Went through the descirption. and the files. “XML Map [login to view URL]” Product Modifier [login to view URL]” [login to view URL] Daily [login to view URL] - Can get the data from the XML files for both locaitons includi More

£400 GBP in 6 days
(52 Reviews)

Hi I am a technical evangelist, developer and can do this task for you. I have more than 12 years of experience in software development and am a microsoft certified professional.I have strong work experience in Reac More

£555 GBP in 10 days
(11 Reviews)

Here my suggestion, we can do your all requirements in MS ACCESS with VBA. If you wish to do this with Excel I will do it. But the access will fulfill your needs with a professional look. Hi Mr. Employer I have lot of More

£555 GBP in 15 days
(81 Reviews)

Hi I am an excel-vba Expert and I can finish your project so fast start the chat discuss more . ....................................................................................................................

£444 GBP in 10 days
(38 Reviews)
£250 GBP in 1 day
(48 Reviews)

I am not a random bidder.. Please check my profile to know more about me and my projects... Please ping me if you are interested with my proposal and share more details if any.. thank you.

£650 GBP in 5 days
(28 Reviews)

Hi Hope you well ! I am Vinod Kumar. I am working as Senior Software Developer in IT company. I have 4 + years experience in .NET with C#,VB,ASP.NET, Web Service, WCF, Javascript, JQuery, SQL, XML ,XSLT and HTM More

£611 GBP in 10 days
(16 Reviews)

Hi there, Thank you for going through my proposal. We have 7+ years experience on freelancer in various domains. We have proven track record of delivering C#/.Net web applications with AngularJS front end. Also More

£750 GBP in 21 days
(2 Reviews)

Hello I am working with MS-Excel and VBA for the past 15 years and have completed successfully many Excel projects. I am ready to do your work and have gone through your project specifications. Give me the job, get More

£250 GBP in 10 days
(22 Reviews)

I have more than 25 years of experience in web/software development and system administration. My latest work is [login to view URL] Have worked on many simple to complex projects in the following Skills Fu More

£694 GBP in 15 days
(4 Reviews)