Hello
I'd like to know if anyone has any experience in using Excel and VBA to collect files from different folders into one.
I have an excel sheet with ID numbers in a column which correspond to file names for images. (i.e., 5943234c46a210294cd7cc4a). This is a filtered list of the larger set of images. I am wondering if there is a way to have excel search for the ID numbers in different sub-folders to collect the filtered list into one compiled folder?
I have no experience with VBA but I am looking to see if this is possible solution.
Thanks
I'd like to know if anyone has any experience in using Excel and VBA to collect files from different folders into one.
I have an excel sheet with ID numbers in a column which correspond to file names for images. (i.e., 5943234c46a210294cd7cc4a). This is a filtered list of the larger set of images. I am wondering if there is a way to have excel search for the ID numbers in different sub-folders to collect the filtered list into one compiled folder?
I have no experience with VBA but I am looking to see if this is possible solution.
Thanks