Đã Đóng

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.



Hi. Thanks for all the bids. I am currently gathering more detailed business requirements and sample files. At that point I will select a handful of finalists, each of which will need to sign an NDA. With the additional info/files that I will provide to the finalists, each will submit a final bid and work plan.

I expect to have all this new information collected by June 6th.

Kĩ năng: Excel, SQL, Visual Basic

Xem nhiều hơn: we excel, vb work, vba work, excel vba db, excel spreadsheet web service, vba and macros, vb in excel, e vb, customer database in excel, customer data in excel, VBA Macros, vba excel, vba excel macro, vba e, VBA and excel, sql work needed, publishing work, Macro vba, macro e, excel with sql server, excel vba macro, excel to sql, excel service, Excel Macro VBA, excel database visual basic

Về Bên Thuê:
( 0 nhận xét ) New York, United States

ID dự án: #1067457

53 freelancer đang chào giá trung bình $1713 cho công việc này


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

$1500 USD trong 15 ngày
(72 Nhận xét)

See your PMB Please...

$1500 USD trong 30 ngày
(140 Nhận xét)

Pls see your messages. Thanks

$1500 USD trong 15 ngày
(70 Nhận xét)

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

$1500 USD trong 14 ngày
(26 Nhận xét)

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 Thêm

$2250 USD trong 5 ngày
(30 Nhận xét)

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 trong 7 ngày
(11 Nhận xét)

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. Thêm

$1500 USD trong 10 ngày
(4 Nhận xét)

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

$1500 USD trong 7 ngày
(12 Nhận xét)

Please see PM

$1500 USD trong 3 ngày
(1 Nhận xét)

Please see PM

$1500 USD trong 14 ngày
(1 Nhận xét)

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 trong 10 ngày
(7 Nhận xét)

Excel Expert here ..., ready to start.

$1500 USD trong 3 ngày
(5 Nhận xét)

Already done a similar project. Kindly check your PMB.

$1500 USD trong 2 ngày
(3 Nhận xét)

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

$1500 USD trong 15 ngày
(1 Nhận xét)

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 / Thêm

$1500 USD trong 5 ngày
(3 Nhận xét)

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 Thêm

$1500 USD trong 3 ngày
(1 Nhận xét)

Please read my proposal.

$1500 USD trong 14 ngày
(1 Nhận xét)

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 trong 5 ngày
(2 Nhận xét)

pleas check pm i specialise in excel vba.

$1500 USD trong 15 ngày
(1 Nhận xét)

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 Thêm

$3000 USD trong 12 ngày
(1 Nhận xét)