Fellow Forum Members,
I want to know if Calc can perform the following operation without needing advanced programming skills. Here is the my CALC layout:
- Column A = List of 100 PDF unique file names
-
Column B = List of Path to source folder
where 500 PDF files reside. 100 Cell Path Filldown
Example: /home/sandbox/Source_data -
Column C = List of path to Destination Folder. 100 Cell Path Filldown
Example:
/home/sandbox/Destination_Folder
I need CALC to move the 100 PDF files listed in Column A from the Source_data folder over to the Destination_Folder. In short, after executing this operation I should end up with 100 PDF files inside the Destination_Folder that match the file names listed in Column A. Additionally, the Source_data folder PDF file count should change to 400 because of how CALC automatically moved the 100 PDF files listed in Column A.
Can CALC perform such an operation without needing advanced programming skills? Better yet, can such a Macro already exist somewhere online as a VBA code share?
Lastly, I already tried performing the same operation using the TERMINAL but that turned out to be a dead end for me due to the complexity of the commands.
Any help will be greatly appreciated. Thank you for your time.