Closed

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

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.

You must be local to Seattle Washington to be considered for this project as we need onsite consultation.

Skills: C# Programming, Perl, Shell Script, Visual Basic

See more: seattle excel automated mechanism, visual programming language, visual programming c++, visual basic programming service, vb work, vba work, vba programming language, vba programming in excel, vba excel programming, the most needed programming language, the d programming language, sql programming language, programming macros, programming language definition, programming language d, programming in vba, programming in excel vba, programming excel spreadsheets, programming definition, office dept, ms office programming, ms lookup, ms excel programming, is sql a programming language, g programming language

About the Employer:
( 0 reviews ) New York, United States

Project ID: #1571139

17 freelancers are bidding on average $3456 for this job

forrestwang

hi sir, check more.

$5000 USD in 30 days
(20 Reviews)
6.4
svet63

In case you can't get a Seattle pro... Regards, Svet.

$5000 USD in 30 days
(46 Reviews)
6.2
aptecpymefree

We can work in your project. I am a leader of the team. I have 14 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT. Please contact More

$3000 USD in 30 days
(9 Reviews)
5.4
ysrahmed

Dear Sire, I have expert experience in VBA/VB, VB.Net Programming languages. Please see my Private Message Regards Yasser

$3000 USD in 20 days
(20 Reviews)
4.0
esalem

Hello, please see the PM for details.

$4500 USD in 30 days
(1 Review)
1.0
flyteda

hello, 5 years experience in the C#,C++, XML,JS ,Ajax and Mssql field. i am Microsoft Certified Solution Developer.

$3000 USD in 15 days
(1 Review)
1.0
ampplee

I am based out of Las Vegas and on the same time zone as you. I have been programming since 2003 with an engineering background. This has directed me to the business side of things where I have found myself in the sa More

$3000 USD in 25 days
(0 Reviews)
0.0
samcherla

I reside in chicago, but frequently travel to CA. i'm interested. Let me know if you need anything else.

$3500 USD in 30 days
(0 Reviews)
0.0
DimitriOleinik

Hello. I can help you with your data injest project. I have experience doing it with; Matlab, C++ and Java.

$3500 USD in 20 days
(0 Reviews)
0.0
shagoon2u

In Case, you go for remote development, Excel and VBA Experts are ready to start immediately.

$3000 USD in 15 days
(0 Reviews)
0.0
parama4u

Hi, i can do this. Please check PMB

$3000 USD in 10 days
(0 Reviews)
0.0
tyltin

Hi! I worked with databases 10 years and worked with many languages (c#, delphi, assmebler, vb etc...).. I will make it in 10-20 days... if you check me, then we must talk about details..

$3000 USD in 10 days
(0 Reviews)
0.0
FAlgabaM

I live far away from Seattle, but internet keep us vey closed. More than 35 years of experienced in different fields. International software developer, actually living in Guatemala, Central America. I work in Visual More

$3000 USD in 30 days
(0 Reviews)
0.0
engtareq79

Hello,If you don't find local guy,we are glad to do this task for you with our programming gurus. Customer satisfation on top of accuracey is @ the heart of everything we do,best regards,Tareq

$3000 USD in 30 days
(0 Reviews)
0.0
cmsskinss

Hi, We are a california based company expert in Excel Macros VBA programming. Please check our website [url removed, login to view] Project sounds pretty straight forward and we have skill set for VBA programming, .Net C# More

$4000 USD in 30 days
(0 Reviews)
0.0
sahityat

I have work experience of 3yrs in programming and be able to handle the work and complete it on time with good quality

$3500 USD in 30 days
(0 Reviews)
0.0
nitingoyal1808

Hi, I have implemented a similar kind of project having few features similar to the one you are having in your project. Please check my PM for more details.

$3250 USD in 15 days
(0 Reviews)
0.0
Bradley95

Hi, I look forward to working with you on this project. Please see PMB,

$3000 USD in 20 days
(0 Reviews)
0.0