Replacing a value with another value on multiple files in given folder

  • Is there just one worksheet in each of the files?

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • There are multiple files in a given folder.

    Each file has same sheet name "Data"

    In Data sheet at column DI there is formulae containing a value "<25".

    What I need is to find the value "<25" in given column DI and replace it by value"<21".

    It has to be done for all the files present in that folder.

  • Try this, change the path to the required folder where shown (make sure you include a backslash at the end)

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Try this, change the path to the required folder where shown (make sure you include a backslash at the end)

    Great KJ,

    Its Working Fantastic


    Thanks for your great help.

    :love::thumbup: