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.


Job awarded.

Apr 25, 2011

Job Description

  |  Change History >>


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

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
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Christine Leisner      
Christine Leisner'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...
 4.9   |  Private   |  23 Jobs
Bid ID: 23984008  |  Submitted: Apr 25, 2011 13:33 ET 
Within 1 week

 Latvia  |  
I specialize in developing customized solutions based on Microsoft Word, Access and Excel. My aim is to provide high-quality and cost-effective...
 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...
 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...
 0.0   |  Private   |  1 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...
 0.0   |  Private   |  0 Jobs
Bid ID: 23982162  |  Submitted: Apr 25, 2011 11:17 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »