Is it possible to make user-defined fields refer to another based on a variable?

Started by abssorb, January 26, 2012, 04:26:20 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

abssorb

I have a number of shapes which pull a number of attributes from the Page shapsheet.

Shapes have about 10 user-defined cells. Three of which link to the page shapesheet.
E.g.
QuoteFirst shape
=ThePage!Scratch.A1
=ThePage!Scratch.B1
=YEAR(ThePage!Scratch.C1)

Second shape
=ThePage!Scratch.A2
=ThePage!Scratch.B2
=YEAR(ThePage!Scratch.C2)

Third shape
=ThePage!Scratch.A3
=ThePage!Scratch.B3
=YEAR(ThePage!Scratch.C3)

Is there a way to do something like....:
QuoteAll Shapes

User.KeyValue=1
=ThePage!Scratch.A[User.KeyValue]
=ThePage!Scratch.B[User.KeyValue]
=YEAR(ThePage!Scratch.C[User.KeyValue])
?

It would open up a lot of possibilities for where I'm heading with automation.

Yacine

Yacine