Download the featured file and VBA code here https://www.bluepecantraining.com/copy-all-highlighted-coloured-cells-to-another-excel-worksheet/

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.

This video will be useful if you are asking the following questions:

How do I transfer certain colored cells to other Excel sheets?
How do I copy only highlighted cells in Excel?
How do I to extract highlighted cells in Excel?
How do I copy highlighted cells in Excel from one sheet to another?
How do I copy row to another sheet based on cell color?
How do I copy and paste colored cells to destination using VBA?
------------------------