+ Reply to Thread
Results 1 to 2 of 2

Macro for finding cell value and pasting entire column in new sheet

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    39

    Macro for finding cell value and pasting entire column in new sheet

    Please help in making macro for -

    need to find a column name in a sheet by the value and copy the entire column to different sheet in the workbook.

    for example

    name age place
    mike 25 japan
    jess 23 usa
    nelli 18 china


    now the column headers are - name, age and place ( there could be n number of columns and the order need not be same as shown above)
    Need to Find the column Age - ( it is not the second column) so need to be able to find by the value - "age"
    after finding the column header " age", need to copy the entire column and paste it in separate worksheet.

    please assist

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Macro for finding cell value and pasting entire column in new sheet

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to skip an entire column when copy pasting from another sheet
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-21-2013, 01:25 PM
  2. [SOLVED] Finding data in column a copying to entire row to new sheet
    By ALLEYCAT38 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-05-2012, 04:52 PM
  3. [SOLVED] Macro for Finding Sheet Names, then Copying/Pasting Values
    By Joel.Nemec in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-09-2012, 01:28 PM
  4. finding multiple broad terms in columns then pasting entire rows to new sheet
    By thirdcoast in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2010, 03:19 AM
  5. Copying and pasting entire sheet....in vba
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2010, 07:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1