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 [login to view URL] is about $30-$50

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

See more: excel macro to word, excel macro to get data from website, excel macro to extract data from webpage, 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 create report, export excel xml macro, macro export excel xml, macro export project report excel, xml export excel 2007 vba, macro excel 2007 xml export, xml export excel examples 2007, xml export excel, excel xml export

About the Employer:
( 14 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
(10 Reviews)
3.6

6 freelancers are bidding on average $128 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
(290 Reviews)
7.6
$155 AUD in 3 days
(56 Reviews)
6.2
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
(15 Reviews)
5.2
$155 AUD in 3 days
(6 Reviews)
2.9
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