"Master" shape numbers in multiple pages?

P

papapatent

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.
 
D

David Parker [Visio MVP]

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]!Sheet.30!Prop.Number will refer to the
value in the Prop.Number cell in the Sheet.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 ShapeSheet programming and a lttle
automation to place the right formulas in the right cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top