Hi there,

Is it possible to set the number of rows in a range based on a start and end date?. I'm not sure even how to start this, but if say I has the start date in cell A1 and end date in cell B1, it is then possible to set how many rows will be programatically generated relating to number of month's between the two dates in any defined range. My first row would be made of a series of formula which I would like to be copied down to the end of the range, which would generate a set of figures.

Any help appreciated !

Thanks for your help

John