ips

So this is one IP scenario I've searched high and low for and can't believe I'm this "lucky" to be the only one looking for it. I have a long list of IP's (spanning across multiple c class or /24's) and it also has "ranges" in it and I'd like to have the ranges split out into single IP's...

Hello everyone. I have spent 2 days trying to figure this one out but I feel like I'm at a dead end. I need a VBA or Formula to fill down sequentially from every 15th row. In this case I have a list of IP addresses I'm trying to generate and it looks like this: Column E Row 3 -...

Does anyone have a working VB script to work with IP ranges? For example. I need to "input" the following three IP ranges into Excel and have it converted to single IPs. These as an input: 10.10.30.92 - 10.10.30.95 10.10.64.158 - 10.10.64.161 10.10.66.76 - 10.10.66.77 Would output this...

Hi All, I have two worksheets. 1) IP List : Contains the list of IP's for which I need to import data. 2) Combined data : Where I need to import all the IP data from Site : https://whatismyipaddress.com/ip/193.134.216.101 For single IP I am able to import the data, but I am not able to...

ok so here is what I am trying to figure out. Let's say I have an ip of 192.168.1.1 and I need 13 ips for that range. Thus it becomes 192.168.1.1/28. so what I need is a formula that where I can put the number of ips needed into a cell, the first ip that I plan to use in the next cell and then...