Apologies, do you really need a macro? Type Jan 2013 in cell 1 double click the bottom right corner of the cell and it will populate for as long as theres data in the cell before.