176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Macro for Excel spreadsheet
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.

Description
Date

Job awarded.

Jan 10, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Jan 09, 2013
  • 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: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

We need a Macro to be run on the attached spreadsheet "Collections before" to do the following.

Macro should run from top to bottom.

Step A If there is a value in column H it should mark the cell as Light Purple and go to the cell below, If there is a value in this cell it should mark as Light purple, continue until there is no value in row L and then do a sum of the Light purple cells to the top left of them and colour it Light Purple

Step B If there is a value in column I it should mark the cell as Light Green and go to the cell below, If there is a value in this cell it should mark as Light Green, continue until there is no value in row L and then do a sum of the Light Green cells to the top left of them and colour it Light Green

Step C If there is a value in column J it should mark the cell as Light blue and go to the cell below, If there is a value in this cell it should mark as Light Blue, continue until there is no value in row L and then do a sum of the Light B...

Sign in or Register to see more

Desired Skills
VBA, Visual Basic, Excel, macro
Job ID: 36707239
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Ukraine  |  
INVITED
macro development using VBA (Excel, Word, Outlook, PowerPoint, Visio): - data manipulation, - formatting data, - permutations, combinations, -...
7
  |  
 5.0   |  Private   |  18 Jobs
Bid ID: 36714902  |  Submitted: Jan 10, 2013 01:41 ET 
Proposal SEALED

Devein B.      
Devein B.'s identity has been verified.  Learn More
 India  |  
Winner
Microsoft Excel VBA Programming / Excel Automations
3
  |  
 4.5   |  Private   |  113 Jobs
Bid ID: 36714572  |  Submitted: Jan 10, 2013 01:29 ET 
Delivery
Within 1 day
$20.00

 India
I am a result oriented IT Professional with a Can Do attitude.Have an expertise in Powerpoint,Word and Excel . I enjoy taking up challenges of...
5
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36713728  |  Submitted: Jan 10, 2013 01:00 ET 
Proposal SEALED

 India
Enterprises and individuals find a niche group of data scientists, information specialists and technology integrators in us. We are a team of...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36712439  |  Submitted: Jan 10, 2013 00:11 ET 
Proposal SEALED

Raymond Sid H.      
Raymond Sid H.'s identity has been verified.  Learn More
 Philippines  |  
Save your time and money, let me handle your headaches for you. I will do the job right at the right price. A brief intro of my self: Im a...
2
  |  
 0.0   |  $800 Earnings   |  2 Jobs
Bid ID: 36709603  |  Submitted: Jan 9, 2013 21:49 ET 
Proposal SEALED

 United States  |  
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36708738  |  Submitted: Jan 9, 2013 21:03 ET 
Proposal SEALED

 United States
I have a very good overall knowledge of computers. I also am proficient in many programs including all MS Office applications. I worked in a QA lab...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36707777  |  Submitted: Jan 9, 2013 20:09 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 »