I am a little new to VBA. I have a table of start dates and values which are weekly, fortnightly and monthly payments. I want to expand this table into a new table showing all the dates and values for a 12 month period.
eg Start Date 1-4-09 $100 Fortnightly
Expand to 1-4-09 $100
15-4-09 $100
29-4-09 $100
etc.......
Hope someone can help me.