Hi All,
Hope this makes sense..
I have a spreadsheet i use for my Movie & TV Shows Listing.
I have the following..
Sheet: MOVIES LIST
Column C: FileName
Column D: FileExt
I have the following code that checks for the Filename&FileExt to advise if they exist (this checks my spelling etc are same as file name on NAS).
This works perfectly as i want it.
I am after a way to display a list of Files that exist within the MOVIES folder on my NAS that are not listed in my Column C&D.![]()
Please Login or Register to view this content.
I have tried the following which works but i then have to putinto the column next to it to show TRUE or FALSE.![]()
Please Login or Register to view this content.
I am just after it to display within a particular Sheet extra files which are nor listed in my MOVIES LIST sheet.
![]()
Please Login or Register to view this content.
Bookmarks