jordanburch
Active Member
- Joined
- Jun 10, 2016
- Messages
- 417
- Office Version
- 2016
Hi All,
Looking for code that loops through all folders and looks for a file containing the partial name of Certification Statement and then if it finds that partial file name it then looks for the tab name of cleared - cleared to and then it copies all of that data into a master workbook into one sheet and keeps adding it to the last row and goes downward. I cant seem to find anything that suits that need. Does anyone have any code like that or ideas?
Jordan
Looking for code that loops through all folders and looks for a file containing the partial name of Certification Statement and then if it finds that partial file name it then looks for the tab name of cleared - cleared to and then it copies all of that data into a master workbook into one sheet and keeps adding it to the last row and goes downward. I cant seem to find anything that suits that need. Does anyone have any code like that or ideas?
Jordan