On a sheet named Directory
Starting in A2, I have a list of paths, starting in B2 I have a list of file names.
I'd like a macro that will go to the correct path, and see if the file exist. If it does, then put a Y in G2, if it does not put a N in G2, the number of rows used will vary.
Thanks,
Bookmarks