+ Reply to Thread
Results 1 to 5 of 5

Alter VBA to only pull specific columns, not all

  1. 08-27-2013, 05:26 PM #1
    cronerd is offline
    Registered User
    Join Date
    06-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    42

    Question Alter VBA to only pull specific columns, not all

    Solved thanks !
    Last edited by cronerd; 08-29-2013 at 04:03 PM.
    Reply With QuoteRegister To Reply
  2. 08-27-2013, 05:34 PM #2
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645
    Should be possible, how do you want to copy those columns to the result sheet?
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 08-27-2013, 05:42 PM #3
    cronerd is offline
    Registered User
    Join Date
    06-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: Alter VBA to only pull specific columns, not all

    Hmm, how do you mean? I would just need the data values..
    Reply With QuoteRegister To Reply
  4. 08-27-2013, 06:16 PM #4
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645
    Oops, kind of phrased that wrong I think.

    Where do you want the columns copied to on the result shgwr?

    PS ' shgwr' means 'sheet' in my mobile phone's predictive text language.
    Reply With QuoteRegister To Reply
  5. 08-27-2013, 06:22 PM #5
    cronerd is offline
    Registered User
    Join Date
    06-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: Alter VBA to only pull specific columns, not all

    haha ohh. Just in columns A,B,C,D in the result sheet (starting in row 2 if possible). I don't need them to keep their original columns from the source data. Does that help?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Do I use Count-IF or other formula to pull data from specific columns?
    By jordan1214 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2013, 09:14 PM
  2. [SOLVED] Alter code to work only on workbooks with a specific prefix?
    By james 35 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2013, 09:30 AM
  3. [SOLVED] Pull content of cells with text that ends in specific characters out of several columns
    By caliskier in forum Excel General
    Replies: 3
    Last Post: 04-05-2012, 04:58 PM
  4. Alter value in one cell alter value in multiple cells
    By Bryan Noqw in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-11-2008, 05:31 AM
  5. Pull Specific Data from Columns
    By youngw in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-08-2006, 02:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1