rows similar data divided by an blank row to delete the data if there are 6 or less

[RobinPrice]

I have a lot of rows of data all divided with an empty row and if they are 6 or less all rows need to be entirely deleted any 7 or above need to be kept

hopefully some one can help (attached file)

thanks

[ragulduy]

maybe:

Please Login or Register  to view this content.

(try it on a copy)

[RobinPrice]

Hi Ragulduy,

Excellent it has worked perfect you are a genius I shall be adding to your reputation

also if you have the time can you have a look at this one
http://www.excelforum.com/excel-prog...-into-one.html

Thanks
Robin