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.
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
5 freelancers are bidding on average $108 for this job
Hi,We can give you a Macro to do this We are Expert in VBA
Hi, i can make a C# program which will make all this stuff, contact me if you are interested, thanks.