I have a compressed file consisting of 900+ PDF files. I have an excel reference file that has column A (account #), column B (brokerage #), column C (Entity). Currently all these pdfs are names with the account Number in their title. But I want to rename them to their brokerage # and group the accounts in folders separated by their entities (4 different types).

Is there a macro function to rename a list of pdf's using the account # - replace it with the corresponding brokerage number and group the pdfs in their respective entity folders. I can unzip the original folder before writing any macro but preferably dont want to.

Any help is appreciated.
Thanks