Hi All,
I need some help.
Another person places files in a folder (up to 100) each week. I need to copy a worksheet from a workbook into multiple workbooks in the folder previously mentioned.
I have not started writing the code because I do not know how to systematically open files in a wb one at a time and make a change.
Thanks for the help
BTW - The file names change each week with no consistency