Extracting values from Freeform shapes
I am trying to make a separate data sheet that collects numbers I type into
the Freeform shape text box. For example,
In one of the sheet called "08-02-08" there is a freeform shape named as
"Freeform 26".
In this text dialogue I'd like to type a value of "26" and I want this text
value to transfer over to a sheet called "Data Collect Sheet" cell "A1"
automatically.
If anyone knows how to accomplish this task it would be a great help for me
to let me know. Thank you.
|