I need to create a macro the looks at a list on a sheet and then matching them to a list pulled from a given folder and only display the missing names from the list in a user form list box.
The image attached is of the mater list.
This code pulls all the current files from the given folder.
Screenshot (3).png
So i am created a check to make sure the files have been saved.
looking at the image "check1" list all the files that i need to look for at that time an "check 2" is later.
the image gives the example names and the static names. You can only search by the names listed as the has a random portion in the name.
so in short i need help making a macro the looks at the list in "G" them compares it to "DirectoryListArray" if the value is missing it will display the "correct Name" in the list box of the user form.
Bookmarks