Automating the Process of Renaming the Column Names in Multiple Excel Sheets

Vote count: 0

I have a requirement from the client in which they want us to rename the column from multiple excel sheets which are present in the same directory. There are 70+ excel reports and we are not sure that the particular column is present in which excel file. So every time they ask us to change, all the time we have to drill down all the excel sheets to find out the changes required which is really time consuming.

I thought of automating the process. Since all the files are present under the same directory, can't we use a MACRO,BATCH/UNIX SCRIPTS or any other way by which we can traverse the entire directory and make those changes by performing a find and replace thing.

So my first question is, if this is feasible ? If yes, then can anyone suggest/advice how to work around on this process ?

Thanks in Advance

asked 22 secs ago

Kishanu Bhattacharya

Let's block ads! (Why?)

Automating the Process of Renaming the Column Names in Multiple Excel Sheets