# Extract and paste particular column from excel to new one **URL:** \ **Category:** PowerShell Help\ **Created:** [April 4, 2018, 11:35am UTC](https://forums.powershell.org/t/extract-and-paste-particular-column-from-excel-to-new-one/10443 "2018-04-04T11:35:34Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![satish76](https://avatars.discourse-cdn.com/v4/letter/s/3be4f8/32.png) [@satish76](https://forums.powershell.org/u/satish76)\ **Post date:** [April 4, 2018, 11:35am UTC](https://forums.powershell.org/t/extract-and-paste-particular-column-from-excel-to-new-one/10443/1 "2018-04-04T11:35:34Z")
Dear All, I have 50+ files (Excel) with 4 or 5 working sheets in it, e.g Main, Jan, Feb, Mar, Apr etc. from each sheet in particular column (Fixed) e.g Customer Number in A1), I need to copy the entire column, again there will be gabs in numbers row wise, all visible numbers to copied and pasted in new excel sheet, the task has to performed for 50+ files (Loop through). In total 50\* 3 sheets = 150 Sheets to be processed, all the customer numbers to be populated in to separate excel sheet. If some one can help me to fix this will be appreciated. Kind regards Satish ---
**Author:** ![donj](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/donj/32/137_2.png) [@donj](https://forums.powershell.org/u/donj)\ **Post date:** [April 4, 2018, 11:38am UTC](https://forums.powershell.org/t/extract-and-paste-particular-column-from-excel-to-new-one/10443/2 "2018-04-04T11:38:07Z")
I find I often get better and more useful answers when I ask a specific PowerShell question, rather than just stating a need and hoping someone posts a complete script ;). Have you tried something in particular and gotten stuck, for example? If there’s a specific question, it would be easier to try and aim for an answer. Note that programming Excel from PowerShell isn’t easy all the time. The Excel programmability bits are old, and imperfectly compatible. It would probably be easier to do this entirely inside Excel, using VBA, and Microsoft has several excellent tutorials and example sets for that. ---
**Author:** ![satish76](https://avatars.discourse-cdn.com/v4/letter/s/3be4f8/32.png) [@satish76](https://forums.powershell.org/u/satish76)\ **Post date:** [April 4, 2018, 11:44am UTC](https://forums.powershell.org/t/extract-and-paste-particular-column-from-excel-to-new-one/10443/3 "2018-04-04T11:44:25Z")
Hi Jones, I am not use to power shell, I have tried with SSIS but its not working for me, so thought to give a try with google, most of the options are feasible with power shell. ---
**Author:** ![donj](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/donj/32/137_2.png) [@donj](https://forums.powershell.org/u/donj)\ **Post date:** [April 4, 2018, 11:46am UTC](https://forums.powershell.org/t/extract-and-paste-particular-column-from-excel-to-new-one/10443/4 "2018-04-04T11:46:43Z")
Well, as we’re all volunteers with existing full-time jobs, I’m not sure anyone’s going to be able to jump in and just tell you how to do it. We’re happy to answer specific questions, if you have one, though! I would personally use VBA entirely within Excel, as it would be easier than PowerShell. Good luck! ---
**Author:** ![david-schmidtberger](https://avatars.discourse-cdn.com/v4/letter/d/ba9def/32.png) [@david-schmidtberger](https://forums.powershell.org/u/david-schmidtberger)\ **Post date:** [April 4, 2018, 12:30pm UTC](https://forums.powershell.org/t/extract-and-paste-particular-column-from-excel-to-new-one/10443/5 "2018-04-04T12:30:29Z")
i’ve done a bit of excel work, mostly combining csv files into an excel output. take a look at the module here: > **[Introducing the PowerShell Excel Module](https://devblogs.microsoft.com/scripting/introducing-the-powershell-excel-module-2/)** > > Summary: Guest blogger, Doug Finke talks about his PowerShell Excel module. The PowerShell Excel Module is a brand new, exciting, and better way to interact with Microsoft Excel from Windows PowerShell. Plus for bonus points, you don’t need Excel... its what i’m using ---
**Author:** ![dotnVo](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dotnVo](https://forums.powershell.org/u/dotnVo)\ **Post date:** [May 16, 2024, 8:36pm UTC](https://forums.powershell.org/t/extract-and-paste-particular-column-from-excel-to-new-one/10443/6 "2024-05-16T20:36:02Z")
Closed on May 16, 2024, 8:36pm UTC