Hello
I have file in folders and subfolders within this device "D:\REPORT\DATA"
so the files in folder and subfolders like this "D:\REPORT\DATA\PAID INVOICE NO 54,300.00"
"D:\REPORT\DATA\REPORT\RECEIVED INVOICE NO 15,056.00
most of extension for all of files will be excel All kinds .
the result will be in OUTPUT file is open to run the macro
the macro should do
1- make headers (ITEM,NAME FILE,MONTH ,RECEIVED,PAID)
2- auto number in column A
3- brings file names from folders, subfolders without extensions in column B.
4-brings month number in column C based on modified date in column C.
5-brings amount based on PAID , RECEIVED are existed in file name.
6- ignore any file doesn't contain PAID,RECEIVED words.
7- I expect to reach files counts could be 100 files through year .
8- should insert TOTAL row to sum column D,E
9- every time run the macro should replace data for OUTPUT file.
10- finally without forgetting numbers formatting.
I hope finding help from experts.
Reply With Quote