Hello Steje,
here are answers:
Does the Excel sheet always list ALL of the image files in the folder you want to process? Yes
If the Excel sheet will always list all of the files in the folder you want to process, then why should a solution need to look at the Excel sheet at all? The idea is the ability to automatically cut down the main Excel sheet in many smaller Excel list (72 jpeg each) then duplicate a template folder with an incremental number and have the files inside have the same name as the folder. And then select the jpegs from the main folder and move them to each incremented folders.
Maybe related to the answer to question 1, does the order in which the files need to be moved into sub-folders matter? Absolutely every list are sorted alphabetically by the locations column and then alphabetically by the last name column.
Does the Excel sheet perhaps list them in some order that makes a difference? Can you simply take the first 72 files, move them into a folder... the next 72 files... move them into the next sub-folder... etc? No this is because the sorting of each jpegs from location and by last name.
You mentioned folder names like B,C,D,E... etc. Was that just an example? If so, is there some naming convention for the folders you want the files to be moved into? Yes that was an example, and the naming convention is based on a specific date and each folders have an incremental number. Inside each folder there is 3 other subfolders and one After Effect project, one exel sheet with the same name as the folder name.
Example:
1566_72up_060914
--->Bitmap {folder}
--->Not_Listed {folder}
--->Output {folder}
--->1566_72up_060914.aep
--->1566_72up_060914.xls
1567_72up_060914
--->Bitmap {folder}
--->Not_Listed {folder}
--->Output {folder}
--->1567_72up_060914.aep
--->1567_72up_060914.xls
etc...
You mentioned also wanting a new Excel file in the sub-folder, listing the sub-folders 72 images. You also mentioned deleting the other columns from the original Excel sheet wouldn't be a problem... I changed my mind about that.
Don't you need the data from the other columns in the original Excel sheet to be in the new sheet for the 72 images it's supposed to list? If not, what is the new sheet for, and can it be a simple CSV instead of an actual Excel sheet? I need all data and column and i need an .xls sheet not a .csv
For more info look at the other tread i made about Copy sequential folder with increment: