abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,507
- Office Version
- 2019
- 2010
- Platform
- Windows
Hello ,
I have files PDF or xlsm, xls, xlsx,csv in this directory C:\Users\ASIF\Desktop\TM\ and every file contains word INVOICE NO & #,##0.00
I want sort files character word INVOICE NO & #,##0.00 and ignore others files .
example FILE NAME: INVOICE NO 12,000.00
MODIFIED DATE : 22/09/2024 AM 02:45
example FILE NAME: INVOICE NO 13,000.00
MODIFIED DATE : 23/09/2024 AM 04:45
example FILE NAME: INVOICE NO 14,000.00
MODIFIED DATE : 23/10/2024 AM 01:45
example FILE NAME: INVOICE NO 16,000.00
MODIFIED DATE : 23/10/2024 AM 04:45
so should create folder like this INVOICES_2024 based on current year
then will create folder based on modified date for the SEP month within INVOICES_2024 folder
the folder will be Sep and move files to SEP folder and will be sort for the last modified date
result for dates in September like this will show first INVOICE NO 13,000.00
second will show INVOICE NO 12,000.00
as to OCT folder will create folder based on modified date for the OCT month within INVOICES_2024 folder
the folder will be OCT and move files to OCT folder and will be sort for the last modified date
result for dates in September like this will show first INVOICE NO 16,000.00
second will show INVOICE NO 14,000.00
last thing should be sort EXCELS files before PDF files
always should sort files from the last date to first date
thanks
I have files PDF or xlsm, xls, xlsx,csv in this directory C:\Users\ASIF\Desktop\TM\ and every file contains word INVOICE NO & #,##0.00
I want sort files character word INVOICE NO & #,##0.00 and ignore others files .
example FILE NAME: INVOICE NO 12,000.00
MODIFIED DATE : 22/09/2024 AM 02:45
example FILE NAME: INVOICE NO 13,000.00
MODIFIED DATE : 23/09/2024 AM 04:45
example FILE NAME: INVOICE NO 14,000.00
MODIFIED DATE : 23/10/2024 AM 01:45
example FILE NAME: INVOICE NO 16,000.00
MODIFIED DATE : 23/10/2024 AM 04:45
so should create folder like this INVOICES_2024 based on current year
then will create folder based on modified date for the SEP month within INVOICES_2024 folder
the folder will be Sep and move files to SEP folder and will be sort for the last modified date
result for dates in September like this will show first INVOICE NO 13,000.00
second will show INVOICE NO 12,000.00
as to OCT folder will create folder based on modified date for the OCT month within INVOICES_2024 folder
the folder will be OCT and move files to OCT folder and will be sort for the last modified date
result for dates in September like this will show first INVOICE NO 16,000.00
second will show INVOICE NO 14,000.00
last thing should be sort EXCELS files before PDF files
always should sort files from the last date to first date
thanks