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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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
|
|||
|
|||
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 | |
|
|
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 03:07 AM |
SUGGESTION: Shape search enhancements | tlonski | Visio | 1 | November 27th, 2004 09:39 PM |
How do I remove multiple text boxes on multiple pages after expor. | Word expert needed | Page Layout | 1 | November 20th, 2004 11:50 PM |
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 |