I am having the below excel file:
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.