Dears,
Good day! I would like to create a table based on the Network Address on Cell B3 and C3.
On the sample, item 1, based on cell value on C3 which is /29, only get the 29 and check it on sheet3.
on sheet3, you'll find the value 29 on col C and @ col D which will tell how many rows will be added on the last row of table @ Sheet2.
From there you'll see a value of 8 which will be the start and end of the row to be added.
The first value to be added @ col B will be same as the network address on Cell B3 and C3 at sheet 1 which is "10.131.100.248",
since the value 29 having a value of "4th" @ col B @ sheet3, it will increment the value by 1 (but will not exceed the value to 255)
@ 4th value after 3 dot which is the value 248
then increment by 1 and will not be exceed by 255 until it get the number of rows needed, so it will be
10.131.100.249
10.131.100.250
10.131.100.251
...
...
...
10.131.100.255
The first will have a value of "Network" and the last will be "Broadcast" @ col D @ sheet 2.
on Item 2, it will be the same, and you'll notice it has a value of 23 @ cell C4,
The no of rows to be added will be 512 based on Sheet 3.
Then the start value will be based on "3rd" from this value "10.131.102.0", which is 102.
Then increment by 1, so it will be,
10.131.102.0
10.131.102.1
10.131.102.2
...
...
...
10.131.102.255 (since the value should not exceed 255, it should go and increment the 3rd value now by 1 and continue increment by 1 again on the 4th value),
here the number of rows created is 256 row and still need to continue until 512 since it has a value of 512 @ Sheet 3 col D based on the /23.
to continue..
10.131.103.0
10.131.103.1
10.131.103.2
...
...
...
10.131.103.255
The first will have a value of "Network" and the last will be "Broadcast" @ col D @ sheet 2.
br,
ivan