Skip to content Skip to sidebar Skip to footer

Data Analysis

Comparison of two different sheets in Excel with VBA

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…

Read more