troubleshooting Question

Excel Formula To populate numbers

Avatar of Mark Wood
Mark WoodFlag for United States of America asked on
Microsoft OfficeMicrosoft Excel
7 Comments1 Solution9 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros