I've been trying to figure out whether it's feasible to write either VBA, or a Power Automate flow, to help me do a repetitive task. Basically, at the end of every month, I need to move almost 100 PDF's of invoices from one common folder to the corresponding individual project folders.

I have made an Excel sheet that has: The names of the PDF files, the project numbers, and the file paths where the project invoices would go (for example, X:\Projects|12345G Tall Pines Property\Invoices\). Instead of having to move them one by one, using two screens with File Explorer, I'd love to automate this. Because the relevant info is already in Excel, I wonder whether it could be done there. I originally thought Power Automate Desktop, but every month the invoice numbers would of course be different, and it won't be the same exact list of projects being billed.

I envision running a simple Powershell dirlist to get the PDF file names, applying a quick XLOOKUP to pull in the other information, and only having to update a few file paths for new projects each month.

Attached Files

Files_Folders.xlsx (13.4 KB, 18 views)