Most valuable professional
  • Hot Topics

Excel Copy and paste data based on cell color

Hi Guys I am Looking for amacro that copies and paste data based on cell color The macro searchesrows in sheet 1 for highlighted cells (Color Index 3,4,6,8) If a cell is highlightedwith any of the above color index, it copies data from column A and B and Row 1pastes to Sheet 2 starting at A1, next blank row Please see examplebelow Sheet 1 1 2 3 4 5 6 7 8 Sheet 2 1 2 3 4 5 6 7 8

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of March 13, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel