Find filled cell in column, select corresponding rows and copy only selected cells/columns

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!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Apologies for the late response.

Please Login or Register  to view this content.

My pleasure thanks for the rep. points.

Please click the Thread Tools drop down box above your first post and choose solved.

Skywriter,
is it possible to change the order of moved cells?

Please Login or Register  to view this content.

I've tried with the red text, to mix the order but it still takes it 2, 4, 6.



Many thanks

Try this:

Please Login or Register  to view this content.

I think you probably understand the code, but just to make sure.

Please Login or Register  to view this content.

A,B,C is the columns that the data will go into on sheet 2. The 2,4,6 are columns C,F,G on sheet 1. They are offsets from the A column. So you could change the A,B,C or the 2,4,6 which ever is your preference.