Macro to delete certain rows of data within a table

Hello,

I've got a lot of great help and advice from this forum in the past but have hit a brick wall trying to create this macro myself. The example attached details what I want the macro to do and contains some sample data to test.

Basically this button would save a lot of time as the proces is currently done manually.

If somebody could take a quick look it would be greatly appreciated, I don't think it will be difficult for an excel guru to crack.

Extract Rec.xlsx

p's apologies to the moderators for the other random thread I started in error and the sloppy thread title.

Many Thanks

Andrew