Circumvent the Fill Series dilemma on Filtered Data Excel 2013

Hello,

This is my first post, so please forgive me if I do anything against unwritten law. But, I have a filter on my data in an excel spreadsheet and am trying to input a number with decimals for example 123.45.67.8 into a column and drag the black plus sign at the bottom right of the cell downward to have Excel Auto Fill the data. I would like the subsequent cells to be ascending consecutively (i.e. 123.45.67.9, 123.45.67.10, 123.45.67.11 and so on). Yet, it will only copy 123.45.67.8 all the way down. Furthermore, I have no Auto Fill pop-up box where I can change between Copy Cells or Fill Series. I have concluded that you simply cannot do this with filtered data in Excel. However, does anyone know of a formula that will work for what I'm trying to accomplish?

It would be awesome if it could always reference to the value in the cell above and add 1 to the number.
I have tried the INDIRECT("R[-1]C, 0") terminology with a +1 at the end to no avail.

Environment:
-Excel 2013
-Filtered Data in worksheet
-Win7

Thank you!

-Alex H.

Thank you! I did not know that it would be read as text. Thanks for that information. The last value will not go very high. They are actually IP addresses so absolutely no more than 254.

-Alex H.

Wow. Thank you very much! This formula works like a charm. For anyone who sees this in the future just replace the A1 in Ford's formula with the cell name that has the "value" you want to start with.

-Alex H.

Will do! Much appreciated