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:

  • You're welcome.

    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!