Rename column headers on all tabs on an excel workbook based on reference table

[hjiang1217]

Hi there, I know Dynamic Rename tool can rename fields of an excel tab based on reference table (having reference table as Right input and configure Dynamic Rename tool to "Take Field Names from Right Input rows" & select old/new field names). Yet, I have dozens of tabs that need to be renamed per same reference table, how do I do that for all the tabs altogether?

Thanks!

[Aguisande]

Hi @hjiang1217 

I have something that might do the trick for you.

Macro:

Some notes:

- Output FileName as Field should be in Full Path 

- Read <List of Sheet Names> Must be the option in the Input Data Tool

In the Macro Questions:

Select the New File to Save (It'll have the same data as previous, but the Sheets renamed)

The Dictionary is inside the macro (In this case a Text Input), but you can replace it whith whatever you're using now.

Let me know if this helps

Best

[tani1901]

Hi @aguisande,

I find your solution very useful for my question at the momemt.

I would like to ask further how I can run the macro for this situation, where I want to change the column name in multiple sheets of the store report file? 

Sorry I'm not so familiar much with macro yet :(

Thank you!

[Aguisande]

Hi @tani1901 

Maybe it'll be better if you tell me more details about what you need to accomplish.

I built the above workflows 2 years ago, and I don't remember what they do (and for what the post says, it won't work for a different use case that the one they were built for)

Note: Also, I don't think this is a case for an iterative macro either.