Devam Ediyor

100,000 excel fields washed and formatted

I have a master file of 100,000+ records in excel downloaded from our CRM. Each month i receive a separate 100,000 + records from a supplier which can contain updated information and new information.

The master files are structured as follows.

[url removed, login to view] information

2. Additional company information (we call them opportunities at this stage)

Each record will contain 1 and 2 information.

We need to get the 3 outcomes as follows.

1. If record received from supplier matches an existing record(in the master sheet) and matches the opportunity(in the master sheet) then create a batch file of these.

2. If record received from supplier matches an existing record (in the master sheet) but doesnt match the opportunity the we create a batch file of these

3. If not match on ether record or opportunity then create a batch file of these.

The batch fiels that get outputted need to be in maximum 5000 records each as our CRM cannot handle additional loads.

We will also need to be provided with the steps how to do this after the work is complete.

Beceriler: Veri Girişi, Veri İşleme, Excel

Daha fazlasını görün: excel opportunities, batch processing excel data, master excel, need get excel, data structured, need match files excel, excel additional, excel record, create company steps, record excel, formatted, crm opportunities, master excel sheet, data entry existing excel, excel data match, excel contain, excel master sheet, create master file excel, information company excel, crm fields, excel master, crm excel, excel match data, 5000 excel data, processing records excel sheet

İşveren Hakkında:
( 1 değerlendirme ) Sydney, Australia

Proje NO: #4400621

Seçilen:

JackBradford

Hi, I have been working with Excel/Macros/VBA for 8+ years. I can develop a VBA Excel program that will automate this process and give you output for the 3 possible outcomes as indicated. If you would like, I can do Daha fazlası

3 gün içinde 115$ AUD
(7 Değerlendirme)
3.5

5 freelancer bu iş için ortalamada 108$ teklif veriyor

Kamalkishover

We have done similar project, Pls Check PM

1 gün içinde 35$ AUD
(211 Değerlendirme)
6.5
srdas2012

Hi,We can give you a Macro to do this We are Expert in VBA

in 7 gün içinde200$ AUD
(3 Değerlendirme)
2.4
omaralieissa

Hi, i can make a C# program which will make all this stuff, contact me if you are interested, thanks.

in 2 gün içinde90$ AUD
(3 Değerlendirme)
2.1
estar87817

Hi. I can do this. Ready to start now.

in 2 gün içinde100$ AUD
(2 Değerlendirme)
1.6