+ Reply to Thread
Results 1 to 5 of 5

Copy columns with a specific headers to another sheet

  1. #1
    Registered User
    Join Date
    02-18-2019
    Location
    Kyiv, Ukraine
    MS-Off Ver
    MS Office 2016
    Posts
    4

    Copy columns with a specific headers to another sheet

    Hi,

    I have more than 30 columns of data, from which I need to copy to another worksheet selected columns.

    Every time, these 30 columns are in different order, the total number of columns also varies, but the name of the column is the same.

    Screenshot_2.png

    Please advise the fastest way to do it.

    Thank you!

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Copy columns with a specific headers to another sheet

    See posts here
    https://www.excelforum.com/showthrea...63146#poststop

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Copy columns with a specific headers to another sheet

    .
    Untested here ...

    https://stackoverflow.com/questions/...column-heading

  4. #4
    Registered User
    Join Date
    02-18-2019
    Location
    Kyiv, Ukraine
    MS-Off Ver
    MS Office 2016
    Posts
    4

    Re: Copy columns with a specific headers to another sheet

    Thanks,

    Could you also help me to edit this code so it would find a bunch of specific columns (like in the example: Number, full name, Work location city, Business group) in row 1 Sheet 1 and past columns in Sheets 2.

    Please Login or Register  to view this content.

  5. #5
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Copy columns with a specific headers to another sheet

    Forgot about column A being empty on Sheet2

    Please Login or Register  to view this content.
    Last edited by nigelog; 02-21-2019 at 08:54 AM.

+ 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] vba code to merge headers from 2 sheets at their specific columns position 3rd sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2017, 11:41 PM
  2. copy specific columns from variable sheet names to specific sheet tab
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2017, 05:50 PM
  3. [SOLVED] vba to copy data by specific headers to a master sheet in same workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2016, 10:08 AM
  4. Replies: 8
    Last Post: 04-04-2013, 08:02 PM
  5. Need to copy ranges from multiple sheets then paste to sheet under specific headers
    By the duke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2013, 12:17 AM
  6. Copy non-sequential columns with headers (from multiple sheets) to one consolidated sheet
    By constantmallee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2012, 02:24 PM
  7. Copy data under specific columns in sheet1 n paste to sheet2 under the same headers
    By ShyamEXcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2012, 02:15 PM

Tags for this Thread

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