Delete Rows & Column Per Conditions....

Hello:

I need a macro to delete certain rows in a spread sheet depending on some conditions.

1. If Row contains word "PCheck with # less then 10000 then delete this row plus 2 rows before and 3 rows after. Please have a look at attached sheet.
In this sheet 1st occurence of "PCheck is on row 4 and there is # 995 which is less then 10000 so i would need to delete Row 4 and Row2,3,5,6 & 7.

2. Similiarly as above if row contains work "PDepsoit...delete rows as above.

If possible may be updated sheet can be copied on sheet1.

Once again thank you in advance for all the help i can get...