Results 1 to 10 of 10

macro needed to extract specific columns out of multiple columns with their row data

Threaded View

genetist macro needed to extract... 01-06-2014, 01:27 AM
hemesh Re: macro needed to extract... 01-06-2014, 01:33 AM
genetist Re: macro needed to extract... 01-06-2014, 01:38 AM
hemesh Re: macro needed to extract... 01-06-2014, 01:41 AM
genetist Re: macro needed to extract... 01-06-2014, 02:14 AM
hemesh Re: macro needed to extract... 01-06-2014, 02:26 AM
genetist Re: macro needed to extract... 01-06-2014, 02:37 AM
hemesh Re: macro needed to extract... 01-06-2014, 02:45 AM
AB33 Re: macro needed to extract... 01-06-2014, 05:01 PM
genetist Re: macro needed to extract... 01-07-2014, 12:49 AM
  1. #1
    Forum Contributor
    Join Date
    04-09-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    176

    macro needed to extract specific columns out of multiple columns with their row data

    Hi to all,
    I have data like this,
    name age Eye color education country village
    pietro 22 red bsc Italy viterbo
    luigi 25 blue msc germany frosinone
    maurizio 34 white msc spain rome
    andrea 35 pink bsc portugal villalante
    anna 65 green msc estonia bagnaia
    giulia 23 black msc finland portis
    federica 27 violet bsc sweden fortna
    Now i want to extract only some columns out of all for example education and village. How can i extract all the columns at a time instead of one by one.

    Expected results
    name education village
    pietro bsc viterbo
    luigi msc frosinone
    maurizio msc rome
    andrea bsc villalante
    anna msc bagnaia
    giulia msc portis
    federica bsc fortna
    in my file i have like more than 10000 columns here i presented only example data. any help would be highly appreciated.
    Thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to combine multiple columns keeping few columns specific
    By lramesh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 12:44 PM
  2. [SOLVED] Extract specific data from columns and creating seperate sheets for each one
    By Tyso in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2013, 06:03 AM
  3. Macro to extract specific Columns
    By bholabhala in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2010, 07:45 PM
  4. code to extract specific data into specific columns
    By lmohaxx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2008, 01:52 AM
  5. [SOLVED] macro help = extract content of specific columns accross a row
    By garyusenet@myway.com in forum Excel General
    Replies: 1
    Last Post: 08-03-2006, 07:55 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1