View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
jeffreyj
 
Posts: n/a
Default How do create a formula to add IP addresses?

Thanks Chip. I will use that.

"Chip Pearson" wrote:

The VBA procedure I posted will do that.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"jeffreyj" wrote in message
...
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.