If I type JAN in A1 and select this and fill across to A12 Excel kindly translates this to a row of month names.
What I would like to do is to type JAN in A1 select and copy this to B1:B12 and have excel give me the list months here instead of 12 JAN's.
Is this possible? I will be using vba to do the copy and paste
John