How do create a formula to add IP addresses?
I know Excel does this. I need a formula so that it updates automatically.
I want to set a cell equal to an IP address in a different worksheet A. And
when I update the IP address in worksheet A, it updates it in B and fills in
the IP addresses below, automatically
"Bob Phillips" wrote:
Just drag and copy them down, Excel does it.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"jeffreyj" wrote in message
...
I am trying to make a formula that adds the last part of an IP address,
such
that when I type in one IP address suchas 147.202.70.132, they
automatically
fill in below sequentially with 133, 134, 135, etc. Can anyone help me
with
this? Thanks.
|