i have a spreadsheet and on sheet a there is a subnet calculator. when i input the data into the calculator it gives me a range of usable ip addresses.
so on sheet Network0 i get the starting ip by using this =('Subnet Calculators'!C18&"."&'Subnet Calculators'!E18&"."&'Subnet Calculators'!G18&"."&'Subnet Calculators'!I18) which works
on sheet "Subnet Calculators the ending ip is here =('Subnet Calculators'!L18&"."&'Subnet Calculators'!N18&"."&'Subnet Calculators'!P18&"."&'Subnet Calculators'!R18)
is there a way to auto populate the numbers between the starting and ending ip's on sheet "Network 0" in row b?
i have attached a sample
My Network Info.xlsm
Open in new window
The above formula placed in a single cell will spill down all the IP addresses, one per row.My-Network-Info.xlsm