Dynamic Rename - Formula Option

[Liz001]

I am running several files through a macro, however I noted that some of the headers are not in the first row of the file. How can I get those headers to be on that first row (same line as ABC Company, name of company changes for each file)?

[afv2688 · Accepted solution]

Hello @Liz001 

Does this help?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[Liz001]

Thank you so much! It worked!