How to add data in datatable columns

[Anil_G (Anil Gorthi)]

@vinjam_likitha

please check this…it is a similar use case…before filtering perform the steps to know row numbers and those can be used to update excel back

How to assign index of original datatable to filtered datatable

@stefi as two datatables are different it might not identify…Also as all the rows have same data also it is difficult with only values as well in this case better to first add a column index and use another loop before filtering and in loop just assign index or row number to each column currentrow("Index") = currentindex.now index will have row numberof each row whcih you can use in further loop dt.Rows(Cint(currentrow("Index")))("edited") = "ignoredrow" cheers

cheers