Fill a series in multiple rows to the next column (1st, 2nd, 3rd...)

[NFranco]

I have 700 rows of data and keep track of what is the current number of billing (for contractual monthly billing purposes). I am able to use the fill option handle to go from one cell to the next and it will give me the correct sequence, for example 15th to 16th. However when I select the whole column and try to drag to the next one to fill series...it only copies the cells! How can I quickly get the next billing number for my 700 rows? Example of column I need to fill series on:[TABLE="width: 80"]
<TBODY>[TR]
[TD]No of Billings (Current)</SPAN>[/TD]
[/TR]
[TR]
[TD]15th</SPAN>[/TD]
[/TR]
[TR]
[TD]13th</SPAN>[/TD]
[/TR]
[TR]
[TD]54th</SPAN>[/TD]
[/TR]
[TR]
[TD]23rd</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]

 

[Snakehips]

NFranco,

Welcome to MrExcel.

I think that you have no option but to do it row by row for the first and second columns.

Thereafter, if you select the previous TWO columns and drag across, by the fill handle, to the next new column it will increment the series in all rows.

Hope that helps.