Re: "Master" shape numbers in multiple pages?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

What you are asking is possible...

The formula in a cell in one shape can refer to the value in a cell of
another shape - even across pages.
For example, the formula =Pages[WAN]!***.30!Prop.Number will refer to the
value in the Prop.Number cell in the ***.30 shape on the WAN page.

The formula =PAGENUMBER() will always show the number of the page that the
shape is on. However, if you have background and review pages, this number
may not be the one you expect.

Also, check out the "Off page reference" shape on the basic flowchart shapes
stencil. It demonstrates synchronised text across pages.

It sounds like you need to do a little Shape*** programming and a lttle
automation to place the right formulas in the right cells.


"papapatent" <papapatent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:57786260-9B6A-473F-8D1E-AB8AE4C0669C@xxxxxxxxxxxxxxxx
>I am not sure if I am using the terminology correctly, but is there a way
>to
> create a shape with a number that I can copy to other pages?
> Specifically,
> here's what I want to do:
>
> 1. Create a box or some sort of holder for text.
> 2. Type the number into the shape (e.g., 102) on Page 1.
> 3. Copy the number to another page (e.g., Page 2).
> 4. When I change the text on the shape in Page 1 (e.g., change it from 102
> to 104), I want the shape on Page 2 to change to 104 as well.
>
> I sometimes also add a "Page Number" field number so that the shape will
> update based on the page that it is on). This is because I always use the
> page number as the starting sequence for numbering shapes. For example,
> all
> new shapes added to page 1 will start with 100, 102, 104, etc.; all new
> shapes added on page 2 are 202, 204, etc.; etc.


.

Quantcast