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.
QM is very flexible, which makes it possible to solve problems in several ways. Here is the solution of your problem using the method .getSelection() for a given matrix as an object.
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.