176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Excel Macro Work
Sign in to Add to Watch List

IT & Programming > Software Application

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

May 26, 2011
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Thu, May 26, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    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

We use an Excel document for a weekly log sheet for a customer and would like to automate a portion of this task. We need to perform the following points.

1) Perform a conditional formatting task for certain cells that contain only numbers. Example: Only apply this script if there is a Yes in A1. If B1 is not between the values of C1 and D1 then fill B1 with Red to make it stand out.

2) One click to create a new sheet with the current readings onto a new sheet so the log can be printed and filled out by hand. Example: Click a button and if A1 has a Yes in it take the value from C1 on Sheet 1 and move it to B1 on Sheet 2. Leave C1 on Sheet 2 blank so it can be printed and filled out by hand. Lock Sheet 1 so it can not be easily changed.

This can be done with a macro, as I believe that will be the easiest way to perform it. We have a sheet we are currently using, and it will be provided after the job is awarded.

Sign in or Register to see more

Job ID: 24441569
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 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...
4
  |  
 5.0   |  Private   |  3 Jobs
Bid ID: 24442260  |  Submitted: May 26, 2011 12:39 ET 
Proposal SEALED

 Serbia  |  
Winner
Professional Service with more than 650 completed projects.
10
  |  
 5.0   |  Private   |  22 Jobs
Bid ID: 24441983  |  Submitted: May 26, 2011 12:20 ET 
Delivery
Within 3 days
$50.00

 India  |  
Team of two with combined skill-set of Excel, VBA, SAS & SPSS. We are also equipped with knowledge of Finance & Statistics. Both of us have around...
5
  |  
 4.9   |  Private   |  24 Jobs
Bid ID: 24441911  |  Submitted: May 26, 2011 12:16 ET 
Proposal SEALED

Christine Garcia      
Christine Garcia's identity has been verified.  Learn More
 United States  |  
Over the last 20 years, I have developed numerous Microsoft Office tools using formulas, functions, macros, VBA, Pivot Tables/Charts, and User...
7
  |  
 5.0   |  Private   |  23 Jobs
Bid ID: 24441747  |  Submitted: May 26, 2011 12:07 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 »