Extract information based on background colour


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.

Leave a Comment

Your email address will not be published.