Highlight new and changed entries in Excel spreadsheet
$30-250 USD
Paid on delivery
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:
+ Category
+ Brand
+ MODEL / TYPE
+ PN (part number, is unique)
+ Product description
+ Currency
+ 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.
Project ID: #1525047
About the project
23 freelancers are bidding on average $40 for this job
My bid consists of an xlsm spreadsheet containing a Control sheet for identifying old and new files and a button to trigger a macro placing conditional formatting on the new file as shown in the sample uploaded in PMB. More
I don't really have enough words to convince you to accept my bid, but all I know is that I can effectively do the work. Just try me.
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.