VBA script to arrange data in excel
This project received 18 bids from talented freelancers with an average bid price of $5 USD / hour.Get free quotes for a project like this
Project Budget$2 - $8 USD / hour
I need a person that can write a VBA script in order to re-arrange cell data in an excel file.
In particular, I need to copy data from a PDF document into an Excel sheet and arrange the data into specific cells.
I am looking for someone that can do this extremely fast. (no line-by-line manual entry as it will take too long otherwise). This should be done within a couple hours or even minutes if you know tricks on how to do it.
PDF & Excel sheet download: [url removed, login to view]
(if the PDF file asks for a password, it is )
Your task is to fill in columns I to column X only as shown in the attached sample.
(The other cells are to remain blank.)
You will see tabs at the bottom of the excel file into which you need to copy the corresponding data.
By the way, to navigate the different sections inside the PDF you can see a table of contents on the right hand side, such as Record Labels, Music Publishers, etc. onto which you can click to get to a section quicker.
- Please inform me in how many minutes/hours you can get it done.
- Please attach a sample of an extraction from a complete section (music supervisors) to see how quickly and how accurately you can do it? (not just 1or 2 lines, but 1 entire section so that I can be sure that you can do it quickly for all.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online