hi experts
I search for macro to create new folder and move the files for each created new folder based on previous month for PC
so every month I have many files contains purchases reports . for instance , take month MAR when the files send me , it will be 1 of APRIL and attach the files in this directory C:\Users\PC AAA\Downloads\REPORT . the macro should create new folder name is REPORT _ 3-2022 based on previous month and move the attached files in main directory in folder REPORT to folder REPORT _ 3-2022 . so if the current month on PC is APRIL should create folder is relating in previous month in PC is MAR and move all of the files are existed from folder REPORT to created new folder REPORT _ 3-2022 and so on for all of the months in current year and when finish this year and enter new year then should start again REPORT _ 1-2023 , REPORT _ 2-2023 . ...
I search for macro to create new folder and move the files for each created new folder based on previous month for PC
so every month I have many files contains purchases reports . for instance , take month MAR when the files send me , it will be 1 of APRIL and attach the files in this directory C:\Users\PC AAA\Downloads\REPORT . the macro should create new folder name is REPORT _ 3-2022 based on previous month and move the attached files in main directory in folder REPORT to folder REPORT _ 3-2022 . so if the current month on PC is APRIL should create folder is relating in previous month in PC is MAR and move all of the files are existed from folder REPORT to created new folder REPORT _ 3-2022 and so on for all of the months in current year and when finish this year and enter new year then should start again REPORT _ 1-2023 , REPORT _ 2-2023 . ...