Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Need VB code for Excel Automation
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.

Feb 3, 2011

Job Description

  |  Change History >>


  • Posted: Tue, Feb 01, 2011
  • 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

What I need or require:
I need to automate a set of Excel functions for my excel bookkeepings. The final product should include all the VB modules and works for excel 2003.

What I already have versus what the provider will deliver:
I have the sample excel 2003 spreadsheets

Other context/requirements that providers will need to know:
1. In the tally.xls, there are three color sections, i.e. orange, blue, and gray. They indicate three different categories. On the right, please enter the formula for volume. I entered an formula in the first orange cell as an exampl.

2. add a vb macro to save the information entered into this spread into a new workbook. The workbook should use the following format for file name
[Label]-[Total Volume]-[Type].xls
which can be read off tally.xls

also, rows without data need to be deleted, except for the row that contain the sum info for the blue section.

color format need to also be removed in the new workbook

3. After a set ...

Sign in or Register to see more

Desired Skills
Visual Basic
Job ID: 22854726
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
Successfully finished over 400 Microsoft Access Database projects and 50+ .net projects. DotNetNuke, DNN 5, DNN7, Microsoft Access 2003 ,...
 0.0   |  Private   |  1 Jobs
Bid ID: 22880434  |  Submitted: Feb 3, 2011 08:09 ET 
Proposal SEALED

 United States  |  
Industrial Engineer with an MBA from the US and a Masters in International Finance from England. More than 10 years of experience in companies such...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 22869493  |  Submitted: Feb 2, 2011 14:17 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   |  2 Jobs
Bid ID: 22869175  |  Submitted: Feb 2, 2011 13:56 ET 
Within 3 days

 United States  |  
I have 9 years of experience in java programming, excel and html
 5.0   |  $99 Earnings   |  1 Jobs
Bid ID: 22866696  |  Submitted: Feb 2, 2011 11:17 ET 
Proposal SEALED

 United States  |  
Providing unique, customized tools and solutions in Excel to analyze, extract, cross-reference, and manipulate data‚?¶all through the use of...
 0.0   |  Private   |  0 Jobs
Bid ID: 22857725  |  Submitted: Feb 1, 2011 22:38 ET 
Proposal SEALED

 United States  |  
I am in the organization business. I believe in data based decisions and to manage by exception.
 0.0   |  $0 Earnings   |  0 Jobs   |  1 verified credential(s)
Bid ID: 22857422  |  Submitted: Feb 1, 2011 22:06 ET 
Proposal SEALED

 United States  |  
I am an expert user of Excel and VBA.
 0.0   |  Private   |  1 Jobs
Bid ID: 22854909  |  Submitted: Feb 1, 2011 17:10 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »