A range of cells has multiple background colours. Depending upon the colour selected by an end user via a cell drop down, those cells (along with information in other columns) should get transferred to another worksheet.
You may refer to my solution in this workbook.
Extract information based on background colour
{ 0 Comments }