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: excel opportunities, batch processing of excel data, how to master excel, master excel, need to get excel, data structured, need match files excel, batch batch excel file, 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 company data sheet excel, create master file excel, data sheet formatted sheet excel, information company excel, crm fields, excel master

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

Proje NO: #4400621



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 Fazla

%selectedBids___i_period_sub_7% gün içinde 115%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(7 Değerlendirme)

5 freelancers are bidding on average $108 for this job


We have done similar project, Pls Check PM

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(211 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)