Macro to delete blank cells and unwanted cells in a particular column

Hi Guys -

Could someone help me out, how to delete blank cells and unwanted cells in a particular column.

On the attached file, I want to retain entire row data between "Accept" & "Total Accept*" on column "B" wherever it reflects.
And to delete the rest of the data.

Any help would be much appreciated.

Many thanks in advance.

Regards,
Nikki

Hi,

Thank you so much for your help

The Macro which you have provided is perfect, but all i wanted is to retain the data between "Accept" & "Total Accept*" on column "B" even if it reflects multiple times.

Is there any way?

Once again thank you.

Yes, i am expecting more than one occurrence of "Accept" block.
It would be much better if we delete the other unwanted rows on the same sheet.

@ Dave - Your macro works good, but it copies the required data onto another sheet. I want the data to be retained on the same sheet and to delete the other unwanted rows.

Thank you guys for your great help

Nikki

Its working perfect now. This is what all i wanted.
Thank you so much for your help

Thanks everyone!!!

Nikki