Macro to delete rows based on multiple criteria

[GaryStone10]

Hi All

I need a macro to delete old data from a large selection of data, in order to keep the size down.

What I want this macro to do is
Check all rows from 5 downwards.
If A5 (date) is less than cell $B$1 AND B5 is not equal to C5 then delete the whole row.

Continue until reaching the bottom.

Can someone please suggest a macro or point me in the direction of a good tutorial.

Thanks in advance
Gary.

 

[GaryStone10]

Its taking around 5 minutes to delete one days data

I think I'll have another look after Easter and see if I can find another way around the problem. Sorting them would be somewhat of a hassle as I am looking every one in seven or so rows being deleted.

Many thanks for eveyones help and a happy Easter to you all.