Please see the attached zip file with a spreadsheet and the folder tree structure for more details.
What I need is a macro that will help me keep the spreadsheet updated with names of new files as they are being added to my directory. Simply put I need to link folder names in the spreadsheet with with appropriate folders in directory and keep the list of files updated with a mouse click.
I need only names without extensions and macro? should be able to discern files already in the spreadsheet from new files added to directory and append the list in red font with names of only new added files.
This is a small project for academic purpose and I thank you for your help!
In addition, the link to the file should be added in the adjacent column and if file has a comment it should be added to the Comments column.