steve400243
Active Member
- Joined
- Sep 15, 2016
- Messages
- 429
- Office Version
- 365
- 2016
- Platform
- Windows
Hello Group, I am looking for a way to open each file in a folder on my desktop. Folder Name is 'Open Files'. And for example if The date in Cell H4 in each File is in the month selected, for Example August 2021. I need it to copy data from cell C3 from each file and post to a new excel file and save on my desktop. If the Date is not in the month selected, or blank, do nothing. I can have several hundred files in this folder to be opened and checked for the specific cells noted. Hope that makes sense. Thank you for the help.