Need to update excel when filter datatable used

hi, forum,
I have a file with data 3000 records, in the first column (close/open) this to record come,
I have to take the open records and rename them by the close after some automation.
the problem is that I used a filter data table to filter open but unable to used write cell, to write closed on that record.

ex:- if the record number 1500 is open
i have to rename it by closed