A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Master" shape numbers in multiple pages?



 
 
Thread Tools Display Modes
  #1  
Old May 9th, 2005, 02:47 AM
papapatent
external usenet poster
 
Posts: n/a
Default "Master" shape numbers in multiple pages?

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.
  #2  
Old May 10th, 2005, 04:56 AM
David Parker [Visio MVP]
external usenet poster
 
Posts: n/a
Default

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.


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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing Selected Pages from a Document Containing Multiple Page Numbering Schemes Don Page Layout 5 January 14th, 2005 04:07 AM
SUGGESTION: Shape search enhancements tlonski Visio 1 November 27th, 2004 10:39 PM
How do I remove multiple text boxes on multiple pages after expor. Word expert needed Page Layout 1 November 21st, 2004 12:50 AM
Can updates on one page filter down to other pages? Mike Visio 4 October 3rd, 2004 07:10 AM
Shape references to shapes on different pages Mark K Visio 1 May 15th, 2004 04:00 AM


All times are GMT +1. The time now is 07:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.