Build a Microsoft Excel Model - Product Reconciliation
Budget: $15 – $25 AUD
Note - I will only look at submissions that answer the specific requirements below. I am expecting this to be initially 2 days work - probably with more after if the work is satisfactory:
Background - I need a model built in excel that allows me to reconcile between two excel files. The source data is regularly being updated, so I need the model to be formula driven to identify any issues that arise from these updates or to cater for adding additional products.
This will require advanced excel skills.
For your submission:
I have attached an excel file with two sheets. The "Master" tab shows the quantity and SKU Lookup Ref required for every instance of the Bundle Lookup Ref on the "Data" tab.
To show you are capable and understand what is required, please submit an excel file showing which rows on the data tab do not match the required Qty and SKU Lookup Ref from the Master tab (based on the Bundle Lookup Ref).
It is late here so I will check responses in 12-18 hours from posting this job
Background - I need a model built in excel that allows me to reconcile between two excel files. The source data is regularly being updated, so I need the model to be formula driven to identify any issues that arise from these updates or to cater for adding additional products.
This will require advanced excel skills.
For your submission:
I have attached an excel file with two sheets. The "Master" tab shows the quantity and SKU Lookup Ref required for every instance of the Bundle Lookup Ref on the "Data" tab.
To show you are capable and understand what is required, please submit an excel file showing which rows on the data tab do not match the required Qty and SKU Lookup Ref from the Master tab (based on the Bundle Lookup Ref).
It is late here so I will check responses in 12-18 hours from posting this job