Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MS Excel - Dynamic Table, Macro, and Add-in to allow user data manipulation
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.


Job awarded.

Mar 1, 2012

Job Description

  |  Change History >>


  • Posted: Wed, Feb 22, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I currently have a data connection established with an Oracle database that will output data into several sheets in an Excel document. I need you to build a macro that can be installed on multiple user machines via an Excel Add-in that will allow the users to format this data, edit it, and produce SQL statements based on the edits in a flat .sql file.

Please see two attachments for detailed requirements, as they are better formatted in the attachments.

The basics of the requirements:
Data is pulled from Oracle. I need the creation of a new worksheet in Excel, with dynamic features based on the data pulled from Oracle. The worksheet will need to allow for users to edit it and then save it. From there I have a formula that will generate a SQL script based on the value of a cell. I will need this formula run for each cell so the macro can then produce a SQL script which can be sent to a DBA and executed.

The details are laid out in much more depth in the attachments. Please make sur...

Sign in or Register to see more

Desired Skills
VBA, excel
Job ID: 28847541
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
Years of experience developing and automating reports for major corporations. Expert in MS Office applications, SQL, and VBA. I also possess...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 28933943  |  Submitted: Feb 27, 2012 14:28 ET 
Proposal SEALED

 Moldova, Republic Of  |  
Experienced MS Office Add-in developer (using VBA), with great knowledge of MS Office suite versions 2003, 2007 and 2010, that can create lot of...
 4.6   |  Private   |  0 Jobs
Bid ID: 28908662  |  Submitted: Feb 26, 2012 08:23 ET 
Proposal SEALED

 China  |  
I am a programmer specialized in C++/C#/Java and in Database Programming, Windows Programming, Network Programming and PDF, Video Streaming, Audio...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 28906610  |  Submitted: Feb 26, 2012 03:17 ET 
Proposal SEALED

 Australia  |  
Freelancer with 10+ years' programming experience of: Customization of Office Macro, Toolbar, Ribbon and Add-in with VBA; Desktop application...
 0.0   |  Private   |  0 Jobs
Bid ID: 28896724  |  Submitted: Feb 25, 2012 08:23 ET 
Proposal SEALED

 India  |  
Expert Android programming / Iphone Programming / Office Applications team with average of 15 years experience areas of expertise - Enterprise...
 5.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 28855228  |  Submitted: Feb 23, 2012 05:52 ET 
Within 3 days

 India  |  
Over the last few years, Ideal Solutions has embarked on the competitive IT environs with an innate ideology of providing end-to-end customized IT...
 5.0   |  Private   |  2 Jobs
Bid ID: 28848195  |  Submitted: Feb 22, 2012 22:31 ET 
Proposal SEALED

 Jamaica  |  
The creation of solutions is the reason that I exist. You are guaranteed quality with a reasonable price. Backing up those statements are my twenty...
 4.9   |  Private   |  7 Jobs   |  1 verified credential(s)
Bid ID: 28848005  |  Submitted: Feb 22, 2012 22:18 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »