Pass Data to Other Sheet

You can set the value in the cell of another sheet by using 'In sheet Set value into cell' action.
As a preliminary preparation, a set destination sheet must be created.

Pass Data to Other Sheet

  1. Open 'Action set setting' dialog.
  2. Drag 'In sheet Set value into cell' action from 'Sheet' tab", then set in the edit area
../../../../_images/img_01.en46.png
  1. Click 'Sheet Selection' button.
../../../../_images/img_02.en44.png
  1. Choose the destination sheet to pass in 'Sheet Selection' dialog, then click 'OK' button.
../../../../_images/img_03.en34.png
  1. Designate the cell address and the value to set in the sheet.
../../../../_images/img_04.en33.png

Attention

If a name is specified for a "cell", it works by referencing the name defined in the destination sheet.
Prior to version 3.3.2, it worked by referencing the name defined on the current sheet.
To have the same behavior as in version 3.3.2 and earlier, turn ON "Use the name of the current sheet in sheet manipulation action cells" in the "Sheet Settings" dialog.
  1. Click 'OK' button.