#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete a row if a specific value exist on another sheet | I_malc | Excel Programming | 1 | 10-06-2014 06:11 PM |
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 |
Exporting workbook specific sheet columns on exit | shabbaranks | Excel Programming | 4 | 08-21-2012 08:00 AM |
Compare data in different columns in an Excel sheet | kgfendi | Excel | 5 | 05-16-2009 05:42 PM |