Update fields in excel


#1

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?


#2

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

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

#3

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.


#4

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.


#5

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