Update fields in excel

Hi all,

I am having the below excel file:

image

I want to generate a template for the ones where column B = Yes
I already have the code for generating the template.
But after it is done, I want the status to be changed from blank to “Done”.

Currently I am trying it with “filter datatable” and then write range, but the problem is that when I write the range I only have the ones that have “column B = yes” while I want to write all the data back to excel, but with updated column C.

Any advice?

You can use the below way. But it’s longer.

  • Use for each row.
  • If row(“ColumnB”).tostring = “Yes”
    • True: row(“ColumnC”) = “Done”
1 Like

You can rather avoid the filter data table, loop through all rows of the complete data table and generate template only if column B is Yes. This way your entire data table is available and only the processed rows have updated value in Column C. You can write the data table back again to the sheet.

1 Like

Thanks, this is indeed what i was looking for.

@kaderms also thanks for your involvment, i think you meant the same as the reply above yours.

2 Likes

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