It appears you have JavaScript switched off.
Freelancer.com requires JavaScript turned on in order to function correctly.
You can find quick and easy instructions on how to turn on JavaScript here : http://enable-javascript.com

Seattle preferred: C# or VB work (or similar) needed

Skills Required

Project Budget

$3000 - $5000 USD

Total Bids

18

Project Description

Ideally you are local to the Greater Seattle metro area, as our office is located in downtown Seattle. It's possible to do this work remotely, but the folks in our Finance dept would prefer to meet in person.

We need an automated mechanism (e.g. Excel macros or VBA) to take customer-provided spreadsheets, MS Word Docs and PDFs (we have hundreds of them, some with many hundreds of tabs), most with identical column names and column order and transfer the data into a single, consolidated spreadsheet (also with a fixed column definition but in many cases the column names of the consolidated spreadsheet are different than those of the customer spreadsheets).

Not all the rows from the customer spreadsheets move into the consolidated spreadsheet. Data in each row will trigger the move (i.e. Publisher = ABC or Publisher = ABC Publishing). Also only certain input columns move over.

Also, sometimes we have to do a lookup against a SQL Server db to determine if the data in a given row should move. (i.e. if this item ID exists in our database, then move the row into the consolidated spreadsheet).This database is accessible via web service calls.

We have no preference of programming language but the final app will should run on a desktop PC and be easy to install.

We'd like to complete this project by the end of May.

Thanks
Dwight

p.s. see the attached samples. They are not identical to the actual input files but very similar.