Hi All and thanks for helping!
I have produced a set of PDF files which are all saved in
Each of these files has a naming convention in the following way
(the xxx stands for the brand)
the yyy stands for account type)
What I need to do is move these PDF’s into one of two directories based on criteria within a CSV, excel or text file.
I will perform the logic of where the files should be sent within this file and within column D provide the file location to which I want to move the PDF.
Please see the attached spreadsheet to further clarify this point.
Basically… If the PDF naming convention contains the account number in column A, I need to move the file to the location specified in column D.
I have looked at as many different solutions as possible and the closed I could find was
Link to poss solution
Anyone have any ideas how this may be achieved?