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 for data extraction and consolidation
Sign in to Add to Watch List

Admin Support > Technical Support

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Aug 11, 2014
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Aug 11, 2014
  • 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

I have a large number of individual spreadsheets (about 1,000) which contain reports which are generated multiple times per day. The reports have the same fields, but the individual values are not always on the same line of each spreadsheet - but they are always in the same order and have labels.

I need to extract 15 pieces of data from Excel spreadsheet and to generate a single spreadsheet for analysis which is set up in 15 columns with approximately 1,000 rows.

So, what the deliverables for this job are:
1. A single Excel sheet with 15 columns and approx 1,000 rows of data.
2. A macros which can be used to perform a similar task on future Excel sheets.

I have attached a few examples of the spreadsheets and a spreadsheet showing the setup for #1 above. If you have any questions, please do not hesitate to ask before bidding. This job may well lead to others as I have related projects coming.

Sign in or Register to see more

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

 United States  |  
INVITED
Rated at Top 10% within Elance Microsoft Excel Skills Test. Rated at Top 10% within Elance Visual Basic Skills Test. Memeber of Elance's Excel...
2
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 60791156  |  Submitted: Aug 12, 2014 15:43 ET 
Proposal SEALED

 India  |  
I am an MIS with an 8+ years of experience in Excel & VBA Macro.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 60789056  |  Submitted: Aug 12, 2014 14:53 ET 
Proposal SEALED

Ofra R.      
Ofra R.'s identity has been verified.  Learn More
 Israel  |  
I'm a 14 years experienced statistician and has 4 years of experience in Web Marketing, Online Surveys and Web Researches. You are welcome to visit...
4
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 60765069  |  Submitted: Aug 12, 2014 06:39 ET 
Proposal SEALED

 India  |  
I am working in Financial Markets since 2007. Completed graduation in Bachelor of Engineering in Electrical & Electronics. Since working in...
2
  |  
 4.1   |  Private   |  5 Jobs
Bid ID: 60754938  |  Submitted: Aug 12, 2014 02:33 ET 
Proposal SEALED

Our object is services to clients timely deliver with high quality of work and cost effective productivity. We offer wide range of all Support...
4
  |  
 4.4   |  Private   |  110 Jobs
Bid ID: 60745991  |  Submitted: Aug 11, 2014 21:59 ET 
Proposal SEALED

Mohammad A.      
Mohammad A.'s identity has been verified.  Learn More
 Bangladesh  |  
Almost 12 years experienced on Data Entry, Excel, PDF, Internet Research works and exactly 4 years practical experience on Freelancing job. Now I...
2
  |  
 0.0   |  Private   |  1 Jobs
Bid ID: 60740917  |  Submitted: Aug 11, 2014 18:06 ET 
Proposal SEALED

 Poland  |  
I am an experienced Excel VBA developer, as well as a business consultant. I create advanced Excel-based tools for SMEs and large corporations. I...
3
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 60739439  |  Submitted: Aug 11, 2014 17:13 ET 
Proposal SEALED

 United States  |  
Over 20 years in the technology industry, leading test teams. I built computers, tested them, fixed them and broke them. I wrote many Excel macros...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 60739337  |  Submitted: Aug 11, 2014 17:10 ET 
Proposal SEALED

Harry B.      
Harry B.'s identity has been verified.  Learn More
 United States  |  
Winner
Specializing in data extraction and conversion using automation tools. Excel expert. Over 30 years experience including software engineering,...
6
  |  
 5.0   |  $1,555 Earnings   |  33 Jobs
Bid ID: 60738082  |  Submitted: Aug 11, 2014 16:30 ET 
Delivery
Within 1 day
$50.00

 United States  |  
I am a professional Excel and VBA Developer with over 20 years of experience developing Office solutions for businesses and individuals. I'm known...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 60736672  |  Submitted: Aug 11, 2014 15:53 ET 
Proposal SEALED

 Indonesia  |  
Ex professional managing two kids at home. Check my skill to see what I can do for you. I'm a smart lady (and my sons too!) doing qualified service...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 60735986  |  Submitted: Aug 11, 2014 15:36 ET 
Proposal SEALED

 India  |  
We have over 8+ years of experience in Admin support. I can do your all type of projects with 100%quality. We have very good skills in Admin...
8
  |  
 4.9   |  Private   |  119 Jobs
Bid ID: 60735204  |  Submitted: Aug 11, 2014 15:21 ET 
Proposal SEALED

Ramesh R.      
Ramesh R.'s identity has been verified.  Learn More
 India  |  
Mission Statement: Professionally committed to provide Value, globally with Technology, Creativity and Quality each time on time at a very...
8
  |  
 5.0   |  Private   |  16 Jobs
Bid ID: 60735139  |  Submitted: Aug 11, 2014 15:19 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 »