Fermé

Excel - Macro Work/Light VB work needed

Need an automated mechanism (e.g. macros or VBA) to take customer-provided spreadsheets (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 data from the customer spreadsheets moves into the consolidated spreadsheet. Data in each row will trigger the move (i.e. Publisher = ABC or Publisher = ABC Publishing).

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.

Thanks

Dwight

Compétences : Excel, SQL, Visual Basic

Voir plus : we excel, vb work, vba work, excel spreadsheet web service, e vb, customer data excel, vba macros, vba excel macro, vba e, vba excel, sql work needed, publishing work, macro vba, macro e, excel vba macro, excel service, excel macro vba, excel database visual basic, excel 2011 vba, macros excel basic, excel row column, sql tabs, excel macro row, trigger vba, excel transfer

Concernant l'employeur :
( 0 commentaires ) New York, United States

N° du projet : #1067457

53 freelance ont fait une offre moyenne de 1713 $ pour ce travail

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

1500 $ USD en 15 jours
(72 Commentaires)
6.5
mrbrave

See your PMB Please...

1500 $ USD en 30 jours
(140 Commentaires)
6.0
vserv

Pls see your messages. Thanks

1500 $ USD en 15 jours
(70 Commentaires)
5.9
greggfletcher

Hello, i can help. Please refer to your PMB. Thanks.

1500 $ USD en 14 jours
(26 Commentaires)
5.9
Krusche

We have already a number of ready solutions for data consolidation (and de-duplication) with comfortable and friendly user interaction. You will receive the first version within 36 hours after we start with clear quest Plus

2250 $ USD en 5 jours
(30 Commentaires)
5.7
gshiels

I am a Management Accountant with 20 years experience and very strong Excel and VBA skills. I've proved myself in the real world, now looking to do the same in the virtual world on this website :) Regards

3000 $ USD en 7 jours
(11 Commentaires)
5.1
mars8246

Hello. How are you? I have techniques of excel automation using Macro, VBA, Office runtime libraries(C++, NET) and i have many experiences of practicing such projects. I can your project in 10 days completely. Plus

1500 $ USD en 10 jours
(4 Commentaires)
4.5
muthumuni

Hello Sir #####... Can you Kindly see PMB for details ...##### Your satisfaction is my success muthumuni (Gold member)

1500 $ USD en 7 jours
(12 Commentaires)
4.1
OniNeko

Please see PM

1500 $ USD en 3 jours
(1 Commentaire)
3.4
StumpCreations

Please see PM

1500 $ USD en 14 jours
(1 Commentaire)
3.4
seanmdale

Hi ChooChoo2247, hope you're well! Kindly see the message I sent you detailing my experience and a very competitive offer. Many thanks.

1500 $ USD en 10 jours
(7 Commentaires)
3.4
guevanjr

Excel Expert here ..., ready to start.

1500 $ USD en 3 jours
(5 Commentaires)
2.9
AccuPro

Already done a similar project. Kindly check your PMB.

1500 $ USD en 2 jours
(3 Commentaires)
2.7
spalmer1

Dear ChooChoo2247, Thank you for posting on Freelancer. Kind Regards, Scott Palmer

1500 $ USD en 15 jours
(1 Commentaire)
2.5
ExcelVBAVeteran

Hello, i have over 3 years Excel VBA experience (my day job), and the sort of work required is more or less what i do in my day job i.e. retrieve data from other spreadsheets or an Oracle db and present it in charts / Plus

1500 $ USD en 5 jours
(3 Commentaires)
2.5
Paranos

I am a US based consultant with immediate availability to work on your project. I look forward to working with on this Re-Bid project and would consider this trial run for future business. See PM for details Regards, P Plus

1500 $ USD en 3 jours
(1 Commentaire)
2.1
kanadyanako

Please read my proposal.

1500 $ USD en 14 jours
(1 Commentaire)
1.8
terwelu

You better to use Excel Addin method for executing this task, so not repeating on my worksheets at all. This addin will doing all tasks just what VBA/Macro does. Let me know

1750 $ USD en 5 jours
(2 Commentaires)
2.8
mlov83

pleas check pm i specialise in excel vba.

1500 $ USD en 15 jours
(1 Commentaire)
1.0
mike121zz

Dwight, this is a fairly simple project yet multiple requests make it tedious even for VBA automation. The way I see it that last part might be cumbersome to call web SQL every time, perhaps there is a way to just imp Plus

3000 $ USD en 12 jours
(1 Commentaire)
1.0