176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

VBA, Excel Expert Needed
Sign in to Add to Watch List

Admin Support > Data Entry

View Change History

The client has made the following changes to the job.

Description
Date

Bidding period ended early.

May 10, 2012

Job awarded.

May 8, 2012

Job awarded.

May 7, 2012

Job awarded.

May 7, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sun, May 06, 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: 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 complicated Macro that was done by a previous coder who had a death in the family and had to leave for few weeks, hence the Macro has some issues that need to be fixed.

Attached are the Macro, the data file and the ACES file.

Here is what needed to be done:

- Remove the code and the sheet that is called Macro 3 as it is wrong and won't be needed.
- If you run Macro 1 and 2 both won't run as there is an error. The column names that need to be compared has to be taken from the sheet called Column Headers, which right now I don't think is working properly. Aces file represents the columns in the aces range file, and parts file represent the data file columns which may change depending on the data file we are working on.
- The should be a place on Macro 1 to define the sheet name in the part file which will be used throughout this Macro workbook as the Column Header sheet and the other checks inside the Macros are used for the whole Workbook Macro.

Worth noting, this s...

Sign in or Register to see more

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

 Pakistan  |  
Five years of experience in data mining, data extraction from simple and complex websites, pdf conversion to excel, word etc. Very good at html...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30359305  |  Submitted: May 7, 2012 02:28 ET 
Proposal SEALED

 India  |  
I have enormous experience in creation of Excel Models, templates, analysis, Macros coding, automation, data cleansing, data linking, report...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30358329  |  Submitted: May 7, 2012 01:32 ET 
Proposal SEALED

 New Zealand  |  
Your project is my number 1 priority. No matter the task, it will be done to your complete satisfaction. We NEVER outsource any of your work. Are...
1
  |  
 0.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 30356680  |  Submitted: May 6, 2012 23:33 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...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30356395  |  Submitted: May 6, 2012 23:09 ET 
Proposal SEALED

Ambia R.      
Ambia R.'s identity has been verified.  Learn More
 India  |  
Winner
ABOUT ME: I am an expert in Microsoft Office Word, Excel, PowerPoint, Outlook and Access with 6+ years of experience. I possess proficiency in...
6
  |  
 4.8   |  Private   |  84 Jobs
Bid ID: 30356381  |  Submitted: May 6, 2012 23:08 ET 
Delivery
Within 1 day
$44.00

 India  |  
Over 3 years of experience in various Administrative task and software development languages with excellent knowledge of database. Familiar with a...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30355516  |  Submitted: May 6, 2012 21:53 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 »