With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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