I have a spreadsheet which displays the payments for each customer.
(See table1)
What I would like is Excel VBA that goes through the table1 details, to
display the next payment for a given year. (See table2) The first
payment date is fixed on a payment date cycle e.g. If the Firth_Payment
date field specifies 2nd day, then the payment will be made on the
second day for that month, quarterly or semi annually event.

table1
Customer Duration First_Payment
1 Monthly 02-Feb-2001
2 Monthly 16-Jan-2002
3 Monthly 02-Oct-2003
4 Monthly 05-May-2004
5 Monthly 07-Aug-2005
6 Quarterly 17-Feb-1998
7 Quarterly 30-Mar-2003
8 Quarterly 30-Mar-2004
9 Quarterly 25-Mar-1999
10 Quarterly 03-Oct-2005
11 Quarterly 06-Oct-2005
12 Quarterly 12-Oct-2005
13 Semi-Annually 01-Jul-1997
14 Semi-Annually 06-Apr-2001
15 Semi-Annually 30-Nov-2005
16 Semi-Annually 31-Dec-2008

Table2
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
02/01 02/02 02/03 02/04 02/05 02/06 02/07 02/08 02/09 02/10 02/11 02/12
16/01 16/02 16/03 16/04 16/05 16/06 16/07 16/08 16/09 16/10 16/11 16/12
02/01 02/02 02/03 02/04 02/05 02/06 02/07 02/08 02/09 02/10 02/11 02/12
05/01 05/02 05/03 05/04 05/05 05/06 05/07 05/08 05/09 05/10 05/11 05/12
07/01 07/02 07/03 07/04 07/05 07/06 07/07 07/08 07/09 07/10 07/11 07/12
17/02 17/05 17/08 17/11
30/03 30/06 30/09 30/12
30/03 30/06 30/09 30/12
25/03 25/06 25/09 25/12
03/01 03/04 03/07 03/10
06/01 06/04 06/07 06/10
12/01 12/04 12/07 12/10
01/01 01/07
06/04 06/10
30/11 30/11
30/06 31/12


Conditions:
Monthly Payments: If the record is monthly, there will be a monthly
payment thoughout the year and the date is based on the First_Payment
date day. For example, take the first payment date record 02-Feb-2001
and for the period 2005 table, will generate a for each month a date
02/02 and 02/02 and 02/03 ....02/12.

Quarterly Payments: If the record is quarterly, there will be 4
payments for the year. Space out into 4 payments, the First Payment
field will be used to determine when the payment month should be made.
For example: First Payment record 17-Feb-1998, will have four payments
and they will fall in