How to filter the data and replace the column values with another in the filtered data at a time

[Adithyeshwar_goud]

you can use
(filter data table) while using it in (foreach row in datatable).
IF you want to compare between to sheets you can use

(vlookup) where we need to have comparable data.

cheers.