Macro that copies and pastes a row based on a certain condition on SAME sheet.

Hello,

I am trying to create a macro that will copy a row with 6 columns on the condition that the 6th column is blank. Then it should paste the rows that meet said condition in another part of the SAME sheet.

Any help is greatly appreciated.

Hello jmm1335,

Please read the information on how to upload a sample workbook in the gold coloured banner at the top of this page.
It will help us enormously to help you.

Thank you jmm.

Cheerio,
vcoolio.