Completed

Excel Macro To Automate Report Creation and XML Export

Automate and excel report which merges 2 lots of data from a transport carrier and internal ERP system and then checks which lines meet the criteria set to generate 2 lists to make contact.

One list called List A is created and then a bunch of reward codes are placed next to each line and burned in the settings tab.

List B is just generted as it

Then creates and XML as per the current template which then will export to the save file locations as specified in the setting tab. All instructions are inside the excel file. Each report can have in excess of 15,000 lines

An advanced VBA specialist could do this in a few hours. I have already done all formatting and layouts so just need you to [url removed, login to view] is about $30-$50

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

See more: export excel to xml, create xml file from excel, how to generate report in excel using vba, how to generate xml file from excel using macro, how to automate excel reports using macros, how to generate reports in excel using macros, excel xml mapping, creating automated reports in excel, excel macro to word, excel macro to get data from website, excel macro to extract data from webpage, excel macro to create report, export excel xml macro, macro export excel xml, macro export project report excel

About the Employer:
( 13 reviews ) Sydney, Australia

Project ID: #16641682

Awarded to:

Salesj23

hi there I am a vba expert having necessary skill to handle what you have stated I have came up with the logic required and I will be able to finish your project within a few hours with everything working perfectly More

$50 AUD in 0 days
(3 Reviews)
2.4

7 freelancers are bidding on average $131 for this job

schoudhary1553

Hi there..... Warm Greetings We came along with your request for Excel Macro To Automate Report Creation and XML Export and we reviewed your project description. We'd like to help you with confidence and satisfy More

$250 AUD in 3 days
(238 Reviews)
7.4
$155 AUD in 3 days
(33 Reviews)
5.5
$155 AUD in 3 days
(6 Reviews)
3.4
vaidyag

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in I More

$100 AUD in 1 day
(8 Reviews)
3.1
$155 AUD in 3 days
(1 Review)
0.8
akioUnity

Hello. I am very interested in this task. I already have extensive experience in Excel Macro development. I had worked on Excel Macro and Vba programming for 3 years. I will do my best. Regards

$55 AUD in 3 days
(0 Reviews)
0.0