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


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

Thank you

use Excel Auto fill range activity and chck if it helps