Excel Macro To Automate Report Creation and XML Export

$30-250 AUD

Completed

Posted

about 6 years ago

$30-250 AUD

Paid on delivery

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

Visual Basic for Apps

Project ID: 16641682

About the project

5 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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 Hope to hear back from you

$50 AUD in 0 day

4.7

(10 reviews)

3.6

5 freelancers are bidding on average $142 AUD 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 satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

$250 AUD in 3 days

4.9

(336 reviews)

8.0

@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 Infosys a top IT services company for more than 10 years and now i have started on my own. As part of my infosys tenure i have been executing projects for Microsoft as a customer across various technologies like DotNet, SQL Server, SSIS, SSRS. have executed many turn key projects for them in their licensing space which is very critical for them. Will be able to leverage this experience to deliver this project successfully. If you can provide more details about the work then will be able to provide a more accurate pricing and timelines. Thanks Regards Vaidy

$100 AUD in 1 day