Excel Spreadsheet to list all files in Directories and subdirectories and sort folders by latest FILE last modify date
Closed - This job posting has been filled.
You will develop an excel spreadsheet that will grab a directory listing of all folders, subfolders and files.
We should then be able to sort the Folders and subfolders by the LAST MODIFIED DATE or LAST ACCESSED DATE of the youngest or oldest FILE in the folder or subfolder.
The Folder and subfolder will also provide a calculation of the file sizes within the folder or subfolder.
The idea is to be able to find files and folders which haven't been used for awhile and to be able to archive them.
The engagement will be completed when I have successfully tested the supplied spreadsheet against several test directories that we have created for the purpose.