How do you write a formula across multiple cells and columns?

Help Studio
, ,
1

Hello,

I was trying to copy data from from first sheet called “Data Tab” into new sheet called “Formula Tab” using the formula =‘Data Tab’!A1

How can I write the this formula on cells A1:C15?

I’m using Write Cell activity with following fields

  1. What to write - “=‘Data Tab’!A1”
  2. Where to write - Excel.Sheet(“Formula Tab”).cell(“A1”)

I tried to change the range but it didnt work, maybe my expression needs change as it only printed on cell A1
image

Thank you

2

use Excel Auto fill range activity and chck if it helps