176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Automated data extraction from PDF to Excel
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Nov 20, 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
  • W9 Not Required
Sign in to view client's details

I have one client that sends me purchase orders in PDF live format and they always have the same layout (they are generated from SAP Crystal Reports).

1) In the first lines of the PDF are stated the PO number and the job number - I need to pull out that data from the PDF and add them to my invoice template in Excel.

2) The invoice to be filled must also take a progressive numbering from another Excel file that contains the list of the issued invoices (this file is on my DropBox account)

3) The solution must work on MacOs, as well as Windows; must be compatible with Microsoft Office since the invoice to be filled is in Excel format.

I need a cost-effective solution that will make me save time and replace the copy-paste I have been doing for ages.
Ability to handle multiple PDF and generate the relevant invoices in bulk is a plus.
------------------------------------------
Added 20 NOV 2012, 16:21 PM EST
I believe this can be done my automating the followings:
1) save PDF as Exce...

Sign in or Register to see more

Desired Skills
MySQL Administration, PHP, VBA
Job ID: 35367712
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Siam Computer      
Siam Computer's identity has been verified.  Learn More
 Bangladesh  |  
I Am Mainly A Expert Software Developer, I can give your soft as per your requirement
5
  |  
 5.0   |  Private   |  3 Jobs
Bid ID: 35444895  |  Submitted: Nov 23, 2012 09:47 ET 
Proposal SEALED

 Pakistan  |  
I am an experinced programmer in Php, drupal and joomla HTML SQL ...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 35380106  |  Submitted: Nov 21, 2012 02:37 ET 
Proposal SEALED

 Croatia (Hrvatska)  |  
I love to put ideas to work. This ambition has made me learn VBA manipulation of AutoCAD, CATIA, and MSOffice. I have learned to utilise other...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 35378724  |  Submitted: Nov 21, 2012 01:42 ET 
Proposal SEALED

 Pakistan  |  
“Moiz did a fabulous job. quite simply a 5 star experience. He provided a solution which went beyond my understanding of what was even possible....
9
  |  
 4.8   |  Private   |  29 Jobs
Bid ID: 35378709  |  Submitted: Nov 21, 2012 01:41 ET 
Proposal SEALED

 Poland  |  
I am an experienced Excel VBA developer, as well as a business consultant. I create advanced Excel-based tools for SMEs and large corporations. I...
10
  |  
 5.0   |  Private   |  72 Jobs
Bid ID: 35371102  |  Submitted: Nov 20, 2012 19:13 ET 
Proposal SEALED

Stony C.      
Stony C.'s identity has been verified.  Learn More
 China  |  
I am a 9+ years experienced developer. A real java expert, Good at OOD, OOP, and can control Java thread completely. can use Swing, JMS, EJB,...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 35370942  |  Submitted: Nov 20, 2012 19:00 ET 
Proposal SEALED

Mrt Solutions      
One or more team members at  are verified.  Learn More
 United Kingdom  |  
International company specialized in offshore IT outsourcing projects to clientele world-wide . Developing world-class yet cost effective solutions...
4
  |  
 5.0   |  $2,187 Earnings   |  4 Jobs
Bid ID: 35368862  |  Submitted: Nov 20, 2012 16:56 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 »