Script to Copy from a Variable Range(Array) and Paste to a Variable Range(Array)


In the attached model I wish to copy from Matrix1::Forecast the cell values to Matrix1::Archive.

This is possible by using the code
But what I’d really like to be able to do is have in Matrix2::To and Matrix2::From respectively be the Item names from Category A in Matrix1 that I can select and have the cell values copied To and From in Matrix1.
For instance, I want to copy values from Forecast to Archive3, or from Archive to Archive2 and I simply want to make my selection in Matrix2 and have the script written in a way that it will do this for me automagically.

Thank you!

S A U Answered question January 24, 2019

Thank you for your response.  This works for the model I provided above, but what if I have a grouped item I want to copy it to.  Can you give me the code for that as this seems not to work.  

QuantrixAuthority Answered question January 24, 2019
You are viewing 1 out of 3 answers, click here to view all answers.