Extract, combine and export data from multiple sheets in Excel workbook

This project was awarded to excel4engineers for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description

I am looking for someone to develop a simple web or desktop application that will parse an excel workbook containing multiple sheets that will manipulated according to some rules. The application should do the following:

1. Take an excel workbook containing multiple sheets (A, B, C, D ...) as input.
2. Parse the data from the workbook.
a. From Sheet A
i. Copy a particular Row 1
ii. Paste it into the first row of Sheet D
b. From Sheet B
i. Copy the row(s) related to Row 1 in Sheet A
ii. Paste into the 3rd row of the Sheet D
c. Export the Sheet D as tab-delimited text file

3. Repeat this process n times for different rows in Sheet A.

This project should either be implemented as PHP web app or a Java desktop app. VBA can also be used. Copious amount of documentation is also required. This project is very urgent and implementation should be completed within a few (2-3) days.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online