Excel Keyboard Shortcuts
Ctrl+O = Open
Ctrl+P = Print
Ctrl+S = Save
Ctrl+U = Underline
Ctrl+B = Bold
Ctrl+X = Cut
Ctrl+C = Copy
Ctrl+V = Paste
Ctrl+W or Ctrl-F4 = Close
Ctrl+Z = Undo
Ctrl+N = New Workbook
---
Microsoft Excel Tips
1) Creation of SKU QR Codes in Excel with a button (VBA)
2) Creation of Product URL QR Codes in Excel with a button (VBA)
3) Creation of SKU Barcodes in Excel with a button (VBA)
4) Update of ‘Product’ Column with SKU, Name, Attribute 1 value(s), Attribute 2 value(s), Type and Regular Price with a button (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…