Hi Guys,
I have a excel receipt system which has macros that I can just press a button and it saves the finished invoice documents into a folder structure with its corresponding months, years and days..
Now that I have a year full of monthly folders and days, IE:
(folder -June15)
files-
1000.xls
1001.xls
1002.xls
etc...
Can any one please help me to write a macro that I can do that checks every folder for xls files from 2015 (july14-june15) and looks at a specific cell to see the total $?.. IE: Cell H15 from every single .xls file, and adds each one together to give me a total sum for the year?
Any help is immensely appreciated!
Val
Bookmarks