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.