How to select cells of the same color and move them while maintaining their position?

Question

Visual Basic

It is necessary to select cells of the same color in an excel column, copy, and transfer to another column. At the same time, without violating the order when copying, for example, if cells a34, a35 and a37 are selected, then when copying, let's say in column b they were inserted in the same place, but without touching cell b36 (a36).
I've been searching all day, nothing is right. I found a macro that copies nonadjacent cells, but the problem is that it pastes them in order. Are there any add-ons with ready-made solutions?

Answer 1

0. Apply a filter by color.
then 2 options:
1. https://www.planetaexcel.ru/techniques/2/173/
2. Download from here https ://www.asap-utilities.com/download-asap-utili... Excel (free "Home and Student edition"). Install. There is Russian.
Apply a filter by color and run the command "Range" → "Copy selection and paste only in visible cells" https://i.imgur.com/UgxLf8b.png