VBA Macro Creation for Automation of an Excel Report Population

Budget $150 USD
Bids 1
Average Bid $150

We have a new database that cannot export reports in Excel Format, so we are trying to create a work around by exporting data files and then building an Excel VBA Macro to automate the process of compiling and formatting the data within a report template. This report is ran at least once a week with varying sizes of data sets.

Prior to implementing our database, we had an excel report that was used to track data. This excel format is what the we need to automated template to match, with the addition of some columns due to additional information being collected.

I've attached a copy of both the printed report and the excel format, as well as a copy of the data files that are spit out from our database. For the purpose of this piece I combined the contacts and companies into 1 file. If that is necessary going forward we can take a look at that.

The Data Export file will be 2 separate excel files due to nature of database export options. One file contains company profile info with 14 columns of importing data, and a 2nd file with 5 columns of contact information to be imported. The information from the 2 files needs to be combined into the report template, and formatted with limited dynamic scenarios.

I've updated the following files

Post a Project Like This

This project was awarded to

danielgpratidya

Once again a very good result from Daniel's work, work completed on time and on budget, his ability with Excel surprises me every time his expertise is second to non, what a great experience. [11 May, 2015] Very good work once again he y has done a excellent job with the excel spreadsheets. If you require excel work to be done you cannot go past Daniel for a efficient service
About the Freelancer
danielgpratidya Profile Picture

I am an EXCEL vba Expert and one of the top notch translator (ENG-Bahasa Indonesia) in this platform, the largest freelancing, outsourcing and crowdsourcing marketplace in the world. I can do anything with MS. Excel more than you can imagine including: 1. Excel apps, 2. Excel calculators, 3. Excel dashboard, 4. Excel database, 5. Excel formulas and functions, etc... So, don't limit your ideas, when describing your requirements to me. I also do some VB .NET programming but just for little and simple apps/tools. "An EXCELlent work and solution is what you can get. I have never failed as I never give up"

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • danielgpratidya Profile Picture

    danielgpratidya

    Bekasi,  Indonesia

    I am an EXCEL vba Expert and one of the top notch translator (ENG-Bahasa Indonesia) in this platform, the largest freelancing, outsourcing and crowdsourcing marketplace in the world. I can do anything with MS. Excel more than you can imagine including: 1. Excel apps, 2. Excel calculators, 3. Excel dashboard, 4. Excel database, 5. Excel formulas and functions, etc... So, don't limit your ideas, when describing your requirements to me. I also do some VB .NET programming but just for little and simple apps/tools. "An EXCELlent work and solution is what you can get. I have never failed as I never give up"

    PHP, Visual Basic, .NET, and Website Design