http://blogs.technet.com/b/heyscriptingguy/archive/2007/12/04/hey-scripting-guy-how-can-i-cut-a-row-from-one-office-excel-spreadsheet-and-paste-that-row-into-another-spreadsheet.aspxHey, Scripting Guy! How can I cut a row from an Office Excel spreadsheet and paste it into the first unused row in another Excel spreadsheet? -- NC Hey, NC. We apologize if today’s column feels a little damp; as it turns out, those of us in the Seattleen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/heyscriptingguy/archive/2007/12/04/hey-scripting-guy-how-can-i-cut-a-row-from-one-office-excel-spreadsheet-and-paste-that-row-into-another-spreadsheet.aspx#3314617Mon, 22 Feb 2010 21:56:39 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3314617coderover<p>Very nice, Scripting Guy, how about doing something similar using PowerShell. I'm having the hardest time copying the cell values (in columns E, F, I, L and M) from a source spreadsheet to a target one. After the copy I need to convert the target spreadsheet to CSV with only those columns cleaned up for the consumption of a subsequent script :-)</p> <p>I can't get Powershell to stop modifying the source spreadsheet, no matter what how I slice and dice it :-(</p> <p>Any help would be appreciated.</p> <p>Thank you!</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3314617" width="1" height="1">