I've searched for similar threads but couldn't find suitable one.
Macro that searches for filled cells in column A-starting at A2 (Sheet1), selects the corresponding rows and copies cells only in columns C, E, G and pastes them to Sheet2 starting in cell A2 to C2. At the same time it should delete previously found filled cells in column A (presented in Sheet1a) and colour them red, because I want the next loop to find only new filled cells in column A (Sheet1).
When it pastes it to Sheet2 I would need to find last filled row and each time paste it bellow.
Many thanks for suggestions!