Macro help

[Emmily]

Hi i have work task which i'm hoping can be automated. The task is to track clients who are on Payment arrangements according to their payment frequency. Every Tuesday I will manually try and work out which clients i need to chase up for payment based on their frequency. I was hoping there is VBA procedure that can be wrtitten so when i run the code it will filter for those specific clients.

Below is sample data

Excel Workbook
	A	B	C	D	E	F	G	H
1	Title	First Name	Last Name	Company Name	Total	Instalment	Payment Start Date	Frequency
2	Mr	Jamie	Smith	Test1	7,846.64	100.00	29/04/2009	Weekly
3	Mr	Christopher	Bloggs	Test2	5,830.00	50.00	06/04/2009	Weekly
4	Mrs	Brie	Masters	Test3	28,633.44	500.00	08/09/2010	Monthly
5	Mrs	Ben	Buckingham	Test4	800.00	200.00	22/03/2011	Monthly
6	Mr	Damien	Cot	Test5	4,400.00	440.00	22/03/2011	Monthly
7	Mr	Peter	Pesh	Test6	17,811.00	100.00	04/03/2011	Weekly
8	Mr	Neil	Smith	Test7	1,803.00	910.00	07/07/2011	Quarterly
9	Mr	Grant	Denyer	Test8	3,960.00	330.00	08/03/2011	Weekly
10	Mr	Steven	Gerrard	Test9	8,400.00	700.00	08/03/2011	Monthly
11	Mr	Guy	Seb	Test10	4,020.00	100.00	22/03/2011	Fortnightly
Sheet1

 

[jasonb75]

Oops

=IF(I4<>"", OR(H4="Weekly",I$2 -1 -I4 < 7))

The check formula needs tweaking as well.

 

[Emmily]

Oops

=IF(I4<>"", OR(H4="Weekly",I$2 -1 -I4 < 7))

The check formula needs tweaking as well.

Pefecto Jason, it works!!!!! Thanks mate, and also big thanks to Shg441 for his super formula