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 VBA Macro to consolidate data
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.

Apr 25, 2011
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Apr 25, 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

Overview
I have a workbook with an arbiratry number of worksheets, each with a title row, a row of column headings, then three sets of rows each with a group title.

I'd like to get an Excel macro which will
1) Rename each worksheet based on text in the title
2) Consolidated the data from each worksheet into a new summary worksheet
3) Three new columns should be added to the colsolidated data on the summary worksheet 1) ColA = a substring from the title 2) ColB = a second substring from the title 3) The group title each row was taken from

The format of each worksheet will be the same

Some More Details

Line 1) Title (contains company name (e.g. “CORP1”), a “-“ delimiter then a location name (e.g. “LOC1”) followed by the text “Insured Tenant”, then from and to dates
Line 2) Column headings
Line 3) Coverage type – “New Coverage During Selected Period”
Lines 4-? Rows with data concerning coverages. It i...

Sign in or Register to see more

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

Christine Leisner      
Christine Leisner's identity has been verified.  Learn More
 United States  |  
Winner
Over the last 20 years, I have developed numerous Microsoft Office tools using formulas, functions, macros, VBA, Pivot Tables/Charts, and User...
8
  |  
 4.9   |  Private   |  29 Jobs
Bid ID: 23984008  |  Submitted: Apr 25, 2011 13:33 ET 
Delivery
Within 1 week
$50.14

 Latvia  |  
I specialize in developing customized solutions based on Microsoft Word, Access and Excel. My aim is to provide high-quality and cost-effective...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 23983957  |  Submitted: Apr 25, 2011 13:31 ET 
Proposal SEALED

 United States  |  
Top-notch Excel VBA, Access database, SharePoint and Automatic Web Data Extraction developer working with clients for over 20+ years to deliver...
6
  |  
 5.0   |  Private   |  12 Jobs
Bid ID: 23982535  |  Submitted: Apr 25, 2011 11:45 ET 
Proposal SEALED

 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   |  2 Jobs
Bid ID: 23982497  |  Submitted: Apr 25, 2011 11:43 ET 
Proposal SEALED

 China  |  
CHINA WEB EXPERT I have been acting as a freelancer for 8 years, so that I could own a rich experiences and skills in various aspects. I mastered...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 23982162  |  Submitted: Apr 25, 2011 11:17 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 »