G
Guest
Ok I am trying to create a cell that displays an IP address based on a
starting address on the front page. The address that I start this off of is
actually 4 cells (one for each octet) which I am combining together. It
works fine, but my problem is that if I change one of the numbers on the
front page, it doesnt pass the update along to all of the other cells based
on that. My formula is.
=Sheet1!$C$1&"."&Sheet1!$E$1&"."&Sheet1!$G$1&"."&Sheet1!A3
Would love any help you can offer.
Troy
starting address on the front page. The address that I start this off of is
actually 4 cells (one for each octet) which I am combining together. It
works fine, but my problem is that if I change one of the numbers on the
front page, it doesnt pass the update along to all of the other cells based
on that. My formula is.
=Sheet1!$C$1&"."&Sheet1!$E$1&"."&Sheet1!$G$1&"."&Sheet1!A3
Would love any help you can offer.
Troy