Hello,

I might try using an Autofilter on Column G. Select G, Data - Filter -
Autofilter. Filter on 'Bad'. Select A:F and fill the cells, only the visible
cells will fill.

As far as the good cells, filter on 'Good'. Copy and paste to where you
want, then delete the rows (or clear them) on the original, visible cells.

Then remove the filter by selecting to Autofilter again.

All of this can be automated by using your macro recorder and cleaning up
the code a touch (e.g., remove selections, etc...)

Regards,
Nate Oliver