'fill series' for IP adresses?

I have to come up with several ip addresses for peripherals going on the network.

can fill series> down> linear be used somehow?

example: I uses the starting ip range with the next ip address being in an increment of 10 and so on

it would be:…

Thank you


Enter first two in say A1 & A2. Select both (hold shift down while left mouse clicking each). Then drag down using handle.

Note this is good until you reach

BTW your last number is only an increment of 9.

hence why I need the series filled for me…
thank you!