I've searched far and wide but not finding any VBA that meets my requirements, so any help would be greatly appreciated.

I need to go through all rows and compare rows that all have the same value in one column (Number col in the e.g. below) but delete the rows with date outside of the next 30 days (Date col in the eg below).

Hope I haven't confused you but here is an example to demonstrate the above:

ID Date Number Name
***********************************************
1 13-Mar 16 Dan <------- Keep this row
2 15-May 16 Eric <------- Delete this row
3 3-Feb 16 Kevin <------- Delete this row
4 30-Apr 13 Mike
5 4-Feb 13 John

Appreciation in advance.