Hi,
I am trying to create a vba code to filter a column B based on some criteria and then I want to replace the contents of column A of the filtered rows by the value of column A and column B example :
if in column B i have value C0 for example, I want the content of column A to be equal to Chiah C0.
I have succeeded in writing a code to do the filter but I am unable to write the code to replace the content of only the filtered cell.
A file is uploaded as an example.
Thank you in advance.
Regards,
Rasha
I am trying to create a vba code to filter a column B based on some criteria and then I want to replace the contents of column A of the filtered rows by the value of column A and column B example :
if in column B i have value C0 for example, I want the content of column A to be equal to Chiah C0.
I have succeeded in writing a code to do the filter but I am unable to write the code to replace the content of only the filtered cell.
A file is uploaded as an example.
Thank you in advance.
Regards,
Rasha