Table "cells" referencable by shapes

[vojo]

Is there any way to build a table (a shape or group of shapes) such that
another shape can easily (even if manually...automatic links by a 'key" is
ideal but sorely lacking in visio)?

For example, assume I have a table of 4 row by 3 columns and want some shape
to use or place a value in row 3 cell 1....something like
"table.3.1!user.value"

I realize I could build a group where the group has a bunch of user cells
(like
user.3_1, user.3_2, user.3_3) and have each subshape use the group cell to
populate the field and the other shapes just place in group user cell. The
problem is that I would either have to make bunch of tables (2X2, 2X3, 2X4,
3X2, 3X3, 3X4, etc.) or could add colums/rows to the group (but then have to
manually stitch into group) or other manual/tedious methods to build the
table.

What I am looking for is an user friendly way to build such a table and
easily reference (even if manual from other shape, not be too obtuse to
figure out what table cell to reference).

Ie something like embedding an excell spreadsheet and use row/column or name
to reference it.

I dont think hyperlinks will do it...but maybe wrong.

thoughs?

 

[Paul Herber]

Is there any way to build a table (a shape or group of shapes) such that
another shape can easily (even if manually...automatic links by a 'key" is
ideal but sorely lacking in visio)?

For example, assume I have a table of 4 row by 3 columns and want some shape
to use or place a value in row 3 cell 1....something like
"table.3.1!user.value"

That is exactly the way to do it, the main problem is finding the
correct form of the shape's name that you have to use.
You may also need to add Guard( ... ) around the cell formula.

 

[vojo]

yes...I understand that part....the issue is all the collateral mess involved
(shape for every table combination, cant add rows/columns easily, etc).

Trying to find some more slick than just shear brute force.