Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-14-2014, 07:16 PM
malam malam is offline Create a New Sheet from Existing Sheet with Specific Columns Windows 7 64bit Create a New Sheet from Existing Sheet with Specific Columns Office 2007
Novice
Create a New Sheet from Existing Sheet with Specific Columns
 
Join Date: Oct 2014
Posts: 1
malam is on a distinguished road
Default Create a New Sheet from Existing Sheet with Specific Columns

I have a sheet with many columns (A, B, C, D, E, F etc.). I want to copy column B and E in to a new sheet. How do I do it in VBA?
Reply With Quote
  #2  
Old 10-17-2014, 10:01 PM
macropod's Avatar
macropod macropod is offline Create a New Sheet from Existing Sheet with Specific Columns Windows 7 64bit Create a New Sheet from Existing Sheet with Specific Columns Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,234
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Have you tried recording a macro? The macro recorder gives you the basic code you need, though it could do with come tweaking. Besides which, where do you want the copied columns to end up in the destination sheet?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a New Sheet from Existing Sheet with Specific Columns Delete a row if a specific value exist on another sheet I_malc Excel Programming 1 10-06-2014 06:11 PM
Create a New Sheet from Existing Sheet with Specific Columns From an XL sheet ,how to keep the group of columns which match with other XL sheet Zubairkhan Excel 2 03-04-2014 10:57 PM
Removing columns within sheet shabbaranks Excel 2 09-11-2012 05:03 AM
Create a New Sheet from Existing Sheet with Specific Columns Exporting workbook specific sheet columns on exit shabbaranks Excel Programming 4 08-21-2012 08:00 AM
Create a New Sheet from Existing Sheet with Specific Columns Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft