Hello! I have a simple, yet not so simple problem to solve. At work we get hundreds of bank transaction files from the bank. We have an employee who has to go into each file and change the account number to the account name. This is not a value add task if you know what I mean.
I know what the account numbers are and what the account names should be. Looking for a way to run a script (VBA or other) to look at a table of acct #'s/names and make the updates. I can figure multiple ways to do this assuming the user opens each file. I would like to see if there is a way to make the update without opening each file. Maybe a macro that references a table in an open workbook, but updates the closed workbooks?
Thoughts? Thanks
I know what the account numbers are and what the account names should be. Looking for a way to run a script (VBA or other) to look at a table of acct #'s/names and make the updates. I can figure multiple ways to do this assuming the user opens each file. I would like to see if there is a way to make the update without opening each file. Maybe a macro that references a table in an open workbook, but updates the closed workbooks?
Thoughts? Thanks
