Dear members,
I am really new to this so have been tearing my hair for the last 3 days , trying to achieve something.
There is a source folder in which we create files (.jpg, .pdf, .tiff). That folder is always the same and it doesn't contain subfolders.
The destination folder is a bit more complex:
It is created by using the macro from my other Thread here (works very well but needs some cosmetic tweaking),
That existing macro is attached to a button and when a cell is selected (in column containing names of companies) and button pushed, it creates in a folder "Customers" a subfolder with the mane of that customer plus two sub_sub folders, Jobsheets" being the most recently created sub_sub folder.
The structure looks like that:
Customers
└───Company 1
│ └───Orders
│ └───Jobsheets
└───John Smith
│ └───Orders
│ └───Jobsheets
```
So the sub folder .../Customers/ John Smith/ Jobsheets is the latest one.
What I need is addition to the existing macro that moves all files form the source to the latest created /Jobsheets sub_subfolder, doesn't matter in which customers' name folder it is.
The purpose for all that is:
We have a big number of paper jobsheets that need scanning and a spreadsheet containing the customers names.
We scan few jobsheets for Company 1 to folder called scans. Then we press the button inside the spreadsheet, it creates 3 folders for that customer, and moves all scanned docs to the latest created one. Then we repeat the procedure for the next customer, John Smith.
Thanks in advance, that will clear a big mess that I have inherited.