Is there a way to list all IP's between a starting and ending range?
(Below is sheet1 which contains one row called ranges. Each range has a beginning and ending range separated by a dash. Each group is separated by a comma. There can be many groups on this line. IP ranges end at 255 then increment the value to the left and start over with that octet and continue incrementing again) below are two ranges with starting and ending values for each range
Sheet1
A
Ranges
10.90.168.0-10.90.169.255,10.103.240.2-10.103.241.250
(the ... is removed columns that would actually have data. I removed them to shorten the listing)
Sheet2 Output
A
IP's
10.90.168.0
10.90.168.1
10.90.168.2
.....
10.90.169.254
10.90.169.255
10.103.240.2
10.103.240.3
.....
10.103.241.249
10.103.241.250
Thanks
(Below is sheet1 which contains one row called ranges. Each range has a beginning and ending range separated by a dash. Each group is separated by a comma. There can be many groups on this line. IP ranges end at 255 then increment the value to the left and start over with that octet and continue incrementing again) below are two ranges with starting and ending values for each range
Sheet1
A
Ranges
10.90.168.0-10.90.169.255,10.103.240.2-10.103.241.250
(the ... is removed columns that would actually have data. I removed them to shorten the listing)
Sheet2 Output
A
IP's
10.90.168.0
10.90.168.1
10.90.168.2
.....
10.90.169.254
10.90.169.255
10.103.240.2
10.103.240.3
.....
10.103.241.249
10.103.241.250
Thanks