My current code is working almost perfectly. The only problem is that it doesn't find all the instances of the files existence.
The code should search folders for items in column A, add a unique number and store it in that cell.
Example:
If 04062017003-1 is in column A
And 04062017003-1, 04062017003-2, 04062017003-3
all exist in the folders being searched, it should change the cell contents to 04062017003-4
I believe that if the search was done from the first subfolder to the last then the desired results would be produced. (In the example: 04062017003-3 could never exist prior to 04062017003-2 or 04062017003-1)
Folders are arranged in this manner
...2017
...2017\2017-01
...2017\2017-01\2017-01-01
2017-01-02
2017-01-03
2017-01-04
2017-01-05
2017-01-06
2017-01-07
2017-01-08
2017-01-09
2017-01-10
2017-01-11
2017-01-12
2017-01-13
2017-01-14
2017-01-15
2017-01-16
2017-01-17
2017-01-18
2017-01-19
2017-01-20
2017-01-21
2017-01-22
2017-01-23
2017-01-24
2017-01-25
2017-01-26
2017-01-27
2017-01-28
2017-01-29
2017-01-30
...2017\2017-02
...2017\2017-02\2017-02-01
2017-02-02
2017-02-03
2017-02-04
2017-02-05
2017-02-06
2017-02-07
2017-02-08
2017-02-09
2017-02-10
2017-02-11
2017-02-12
2017-02-13
2017-02-14
2017-02-15
2017-02-16
2017-02-17
2017-02-18
2017-02-19
2017-02-20
2017-02-21
2017-02-22
2017-02-23
2017-02-24
2017-02-25
2017-02-26
2017-02-27
2017-02-28
2017-02-29
2017-02-30
And so on...
Here is my current code:
With a form
Bookmarks