We compare spreadsheets on a regular basis and update certain columns from spreadsheet A to spreadsheet B based on a match in SKU. I would like a macro that examples spreadsheet A compared with spreadsheet B and updates info in spreadsheet A. Both spreadsheets should contain two columns, one of which is the SKU column, tghe other column is the data to be compared and updated in spreadsheet A. For any cells in B that fail to match data in A, these cells should be colored red. I need this work immediately so please bid to deliver within 2 hours. Nothing too complicated please!
20 freelancers are bidding on average $10/hour for this job
Hi I am a Chartered Accountant from India. I had a lot of experience in this type of simple excel work. Can deliver you the macro within 2 hours. Thanks Prateek Agarwal