There is the given code,
=RIGHT(LEFT('1'!A3,16),12)
The sheet name is given in cell C2
=INDIRECT("RIGHT(LEFT('"&C2&'!A3,16),12)")
When I try this code, it does not work.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric