Most valuable professional
  • Hot Topics

Excel Code To Open Files Within Folder Make Changes And Close

I need a code that will open dozens of files within a folder in my desktop and if what is found in column A in the active sheet in column AG in each file then it needs to be changed to what is in column B as below. Thanks Excel 2010 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of July 25, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel