copy paste values problem

283 viewsScripting
0

Hello,

I want to write a script that copy values from column to fill them on another column which has already some values that are filled.

I tried the CellOnly.copy() and CellOnly.paste but it did not work because the column where i want to paste values is not all empty.

Thank you.

Tahir Answered question May 16, 2024
0

Hi Marie, try this script:

|Matrix1::B|.items.each{
destinationCat->

if(|Matrix1|.getSelection(destinationCat, |Matrix1::A2|).value == null){

|Matrix1|.getSelection(destinationCat, |Matrix1::A2|).value = |Matrix1|.getSelection(destinationCat, |Matrix1::A1|).value

}

}

Tahir Answered question May 16, 2024
You are viewing 1 out of 3 answers, click here to view all answers.