Category: Excel Tutorial

This video tutorial demonstrates how to copy all coloured/highlighted cells or records to another worksheet using a VBA macro.  In our scenario we have a transaction database and we want to copy all red records (either cell background or font colour) to another worksheet.  You can download the featured file here and copy the featured…

This video demonstrates how to count and sum based on the background colour of a cell. The solution uses custom VBA functions. Download the featured file here. Please note I cannot upload macro enable files to this website, so you will need to copy the code shown below. https://youtu.be/XFpO_q1HJV8 Here are the custom VBA functions…

This video demonstrates how to restrict editing to specific cells using the ScrollArea worksheet property in Microsoft Excel.  A VBA macro is used to specify the ScrollArea on each sheet. The VBA code is triggered by the Workbook Open event. You can download the featured file here. It does not contain the code (which you…