How to append data and append formula in excel column using modern activity

Test1.xlsx (9.4 KB)

  1. I want to append data from sheet 2 to sheet 1 on column A(EU cost)
  2. after writing the data on column A , need to append the formula on column B of sheet 1 on column B (US Cost) as (=A12*1.112)

thanks you

@Syed_Sultan_Ahmed1

  1. Use copy paste range or use read range and then append range activities
  2. Now for formula use write cell formula if formula already not present on atleast one cell
  3. Then use auto fill range activity to fill formula down the cells

Cheers

Hi @Syed_Sultan_Ahmed1
Please find attached solution
let me know if its work for you

Append_Data.zip (52.3 KB)

thanks its working with another approach but your workflow was giving the correct output thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.