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.
14 pekerja bebas membida secara purata $7235 untuk pekerjaan ini
Hi, we have done this type of work before with great [login to view URL] are an experienced group and can do the job with 100% accuracy and in the stipulated [login to view URL] we look forward to work with [login to view URL] can do the sample work Lagi