ALL BUSINESS DATA ANALYSIS ENGLISH ARTICLES MICROSOFT EXCEL TIPS

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 ‘Status’ and ‘Previous Price’
4) Clear Row highlights with a button (VBA)
5) Delete columns ‘Status’ and ‘Previous Price’

YouTube
#mindstormGR #excel_tips / www.mindstorm.gr

Views: 3

Comments are closed.

Pin It

By continuing to use the site, you agree to the use of cookies. / Συνεχίζοντας να χρησιμοποιείτε την ιστοσελίδα, συμφωνείτε με τη χρήση των cookies. more information / περισσότερες πληροφορίες

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close