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.