I have an excel file which has 1 column, data starts in A2 cell (A1=heading)
lets say there's a range of:
18.104.22.168 - 22.214.171.124 in ascending order
I would like somehow to fill in the missing gaps in the correct position, for example:
<automatically insert 126.96.36.199>
<automatically insert 188.8.131.52>
<automatically insert 184.108.40.206>
I would like to get a complete solution / VBA script if possible.
Thanks a bunch.