Macro that deletes the row if requirements fullfill

[BarinaX]

Hello,

I have trouble constructing macro that would automatically check filled rows from the sheet and delete the dummy rows that copied file generates. Dummy rows are recognized by the facts that they don't have data in column A, BUT they have data on column C.

So the macro would have to check on each row if cell on column A is empty and if cell on column C is filled and then delete those rows. Can you help?

 

[SteveO59L]

why not filter col A for blanks and delete?

 

[BarinaX]

Because then it would delete also the rows that have empty cells on both A and C columns, which are not dummy rows.