Hi,

I do a repetitive manual task weekly and I was hoping you could assist me with a vba that can make this mundane task efficient. I have a list of accounts in a file called Accounts file that has the list of Accounts in column A. All the account names start with a unique 5 digit alpha numeric name. I look for these accounts names (files) in 3 separate folders on the same share drive and I create a separate folder called Outliers to save these account files in.
Is there a way I can run a vba from the Accounts list file that will look for all the accounts in column A in the three folders and saves these files in a new folder called Outlier? I will appreciate the help

Regards,
Pi*