Sheet ‘Jan’ is the Product List of Supplier A for January.
Sheet ‘Feb’ is the Product List of Supplier A for February.
Compare them and do the following:
1) Add columns ‘Status’ and ‘Previous Price’
2) Highlight new SKUs with yellow color with a button (VBA)
3) Highlight existing SKUs with different price with green color (VBA) and update columns ‘Status’ and ‘Previous Price’
4) Clear Row highlights with a button (VBA)
5) Delete columns ‘Status’ and ‘Previous Price’
#mindstormGR #excel_tips / www.mindstorm.gr