<div>
Rob,<br />
<br />
You are amazing. Thank you so much for the fast reply.
</div>


Rob,

You are amazing. Thank you so much for the fast reply.

<div>
Thanks! &nbsp;If it works for you, please don't forget to close the question. &nbsp;Otherwise, let me know if you need anything further, or any of it explained.<br />
<br />
Rob.
</div>


Thanks!  If it works for you, please don't forget to close the question.  Otherwise, let me know if you need anything further, or any of it explained.

Rob.

<div>
Rob gave me a fast answer after I was stumped. I very much appreciate the help!
</div>


Rob gave me a fast answer after I was stumped. I very much appreciate the help!

<div>
<div class="content wysiwyg-content">
I have a CSV file with headers FilePath and FileDestination. I can load it in an array with import-csv.<br />
<br />
What I need to do is copy each file from FilePath (eg G:\99999\0001\CientWill1.P<wbr />DF) to the FileDestination (e.g G:\99999\00001\Trusts and Wills\ClientWill1.PDF). Creating the subfolders as needed.<br />
<br />
Something with Copy-Item / Foreach-object using the headers should work, but I've tried a ton of combinations, and had no success. Can anyone give me a bit of help getting this going?<br />
<br />
Thanks,
</div>
</div>


I have a CSV file with headers FilePath and FileDestination. I can load it in an array with import-csv.

What I need to do is copy each file from FilePath (eg G:\99999\0001\CientWill1.PDF) to the FileDestination (e.g G:\99999\00001\Trusts and Wills\ClientWill1.PDF). Creating the subfolders as needed.

Something with Copy-Item / Foreach-object using the headers should work, but I've tried a ton of combinations, and had no success. Can anyone give me a bit of help getting this going?

Thanks,

Need help using a CSV file to copy files to new subfolders using Powershell

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.