Hi all,

1.I have a master excel file for which I read the range and store as dt_datatable1.

2.Then I filter on a certain column “age” on ‘is not empty’. I store this as dt_datatable2

3.Then I perform certain actions on dt_datatable2 (filling in some columns).

4.Then I want to write everything back in the master excel file

I’m stuck at the 4th step. I want to write the dt_datatable1+the data of dt_datatable2 with the data that I just had enriched in step 3. So the data in dt_datatable1 needs to be overwritten for the ones that were in scope of my filter for dt_datatable2.

Thanks.