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 VB Concatenate Columns
Sign in to Add to Watch List

Finance & Management > Accounting

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Apr 09, 2012
  • 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: About $20
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I'm looking for a vb script to concatenate columns of data.

I'm looking for the following requirements below, please refer to the attached excel file for reference.

1. I can enter Data manually into columns A thru E. in a order that looks visually appealing to me.
2. I can run a script to concatenante columns A thu E to column F.
3. Not all columns in A through E will be populated so concatenate should concatenante only those cells with data entered.
4. I'd like a conditional format that changes font color to white for all occurrences of data after the first. Basically I need the data in all cells (column A - E) populated so I can use pivot tables. But I do not want to see it in the table format so I can present data more clearly.
5. If possible, I'd like to have some kind of conditional format that draws a line separating all major projects from each other..

Sign in or Register to see more

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

Zenon H.      
Zenon H.'s identity has been verified.  Learn More
 Canada  |  
Over ten years financial modelling, business application development experience as an Excel VBA coder, I have developed automated spreadsheet and...
5
  |  
 4.7   |  $160 Earnings   |  3 Jobs
Bid ID: 29945667  |  Submitted: Apr 17, 2012 10:40 ET 
Proposal SEALED

 India  |  
I am a finance professional looking for outsourced projects in accounting, book-keeping, reconciliation and complex reporting using excel and SQL...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29924404  |  Submitted: Apr 16, 2012 13:46 ET 
Proposal SEALED

 United States  |  
Senior Financial Analyst and Program Manager with extensive experience in automation, IT, Finance, Budget, Accounting, Analysis, Enterprise...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29810777  |  Submitted: Apr 10, 2012 16:01 ET 
Proposal SEALED

 United States  |  
INVITED
I am an experienced financial analyst who specializes in creating dynamic Microsoft Excel spreadsheets that help you make informed decisions and...
2
  |  
 0.0   |  Private   |  0 Jobs   |  2 verified credential(s)
Bid ID: 29792751  |  Submitted: Apr 10, 2012 01:11 ET 
Proposal SEALED

Amir Rehman      
Amir Rehman's identity has been verified.  Learn More
 Pakistan  |  
INVITED
Belong to Chartered Accountancy profession experience of big4 firm, KPMG International. I provide advanced level services in strategic and...
5
  |  
 4.8   |  Private   |  9 Jobs
Bid ID: 29782263  |  Submitted: Apr 9, 2012 13:49 ET 
Proposal SEALED

 Greece  |  
Business Analyst self employed Essential Functions - Manage, drive and continuously improve data collection, analysis and reporting...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29781863  |  Submitted: Apr 9, 2012 13:31 ET 
Proposal SEALED

Ellen S.      
Ellen S.'s identity has been verified.  Learn More
 United States  |  
INVITED
I have over 10 years of financial modeling, trading and data analysis experience both on the buy side and the sell side. As a previous Chartered...
5
  |  
 0.0   |  Private   |  0 Jobs   |  2 verified credential(s)
Bid ID: 29777158  |  Submitted: Apr 9, 2012 10:07 ET 
Proposal SEALED

 Singapore  |  
Ranked in the top 1% for Financial Statements and top 5% for Financial Analysis, I do freelance work in financial analysis and Microsoft Excel. I...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29776896  |  Submitted: Apr 9, 2012 09:56 ET 
Proposal SEALED

 Singapore  |  
We are business & IT solutions provider who are looking to serve in the area of business management & IT. We provide quality consultation services...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29776440  |  Submitted: Apr 9, 2012 09:33 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 »