Excel and CSV download manipulation of data
$30-250 USD
Thanh toán khi bàn giao
Hi Freelancers,
this is not the sort of job I normally would post so I hope it will make sense.
I am currently downloading an excel list of data from my website which is broken down into field parameters, e.g name, address, email address etc. we also download within this data the products that the customer has purchased, this in most cases will be fairly simple if the customer has bought only one item as this appears on one line in excel. However, if the customer has purchased more than one product the second product purchaed appears on a seperate line in excel. We wish to transfer this data across to an email CRM system but we have a problem. The data needs to be transfered across so that all of the products purchased by the relevant customer appear on one single line in excel, I have attached an example of how our data currently is downloaded. This data is downloaded on a weekly basis with multiple purchases per customer.
What we wish to happen is that once this complete data list has been transfered to the CRM system that we will download weekly and then upload this data to the CRM system. So, the initial part of the project is to create a formula that can attribute any seperate product lines to the customer line in seperate fields. The second part of the project is to formulate either with excel or SQL, any subsequent orders with customers that already in the CRM database are appended to the customer in seperate fields. If the customer purchases the same product regularly for 10 ocassions this product should only be listed in 1 field as it is repeated, however, if the customer purchases something different on the 11th purchase the new unique product is appeneded under a seperate field.
This needs to be a lasting solution so that each unique record will be updated with the latest purchase information on a regular basis.
I hope I have outlined sufficiently the project, I would appreciate any questions if you require further information.
ID dự án: #649581
Về dự án
Được trao cho:
47 freelancer chào giá trung bình$166 cho công việc này
Hi, I have very good experience of xls VBA macros. I will do it exactly as per your requirements. Ready to start it immediately. Interested to work with you long term.
We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.
Hi This is Piyush Patel I have 5 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM
Exceptional quality & Quick work. Please refer to Profile, Reviews & PMB for details. Thanks FAZ