On a regular basis, we receive a pricelist update in the same Excel format (it's basically a table).
As there are thousands of entries, it's very difficult to identify the changes and new additions to the list.
We need a tool (I'm thinking Excel, but I'm open to other suggestions) which updates the old list with new entries.
Your solution must do the following:
1. add ONLY new entries to the old list and highlight them with blue font (based on PN field)
2. update CHANGED entries and highlight only changed cells with red (PN is identical, but other fields differ)
3. unchanged and old entries must remain black and, of course, unchanged
The table header is:
+ MODEL / TYPE
+ PN (part number, is unique)
+ Product description
+ Sale Price
+ 1 Star Program Price
+ 3 Star Program Price
+ 5 Star Program Price
+ Stock info
Attached you can find an Excel file with 3 sheets: new price list, old pricelist before and after your program ran.
25 pekerja bebas membida secara purata $39 untuk pekerjaan ini
Hello, this is my first bid like a freelancer. Your need, is my daly-bussines, in Automotive industry. Will be my pleasure, to provide you on time, the sollution.