topic Re: Replacing visible cell value in excel sheet in Product Forum

Replacing visible cell value in excel sheet

marwagamal — Fri, 19 Apr 2024 00:01:49 GMT

i want to replace cells value from yes to no after applying filter to excel sheet to be more clear i have excel sheet that contains 5 columns i want to apply filter to column number 2 then replacing the visible cell values of column number 5 from yes to no can anyone help me

Re: Replacing visible cell value in excel sheet

Athiban_Mahamathi — Fri, 19 Apr 2024 06:10:04 GMT

Hello,

you can try "Replace in Worksheet" action from MS excel VBO.

Re: Replacing visible cell value in excel sheet

marwagamal — Fri, 19 Apr 2024 09:58:17 GMT

The problem will be in how to determine the search range as i want to replace the values of visible cell after applying filter only not the cell values of the whole worksheet

Re: Replacing visible cell value in excel sheet

Athiban_Mahamathi — Sat, 20 Apr 2024 08:29:13 GMT

You can try giving the range as A:Z , I guess by default only the visible cells will be replaced.

Re: Replacing visible cell value in excel sheet

marwagamal — Sat, 20 Apr 2024 15:03:49 GMT

Thanks it works fine and yes the default replace only the visible cells

I just want another help i don't know how to add the criteria to autofilter as it didn't give me any result