Results 1 to 13 of 13

Search by columns headers and paste all matching columns to another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2020
    Location
    Warsaw, Poland
    MS-Off Ver
    365
    Posts
    28

    Search by columns headers and paste all matching columns to another sheet

    Hi, would you help me with a macro (because I think there is no other option) which will allow to:

    1. Find a match picked from a dropdown list (sheet2) among column headers in sheet1
    2. Copy all columns which will match
    3. Paste those in sheet2 all next to each other

    For Example, if in sheet2 from dropdown list was chosen "Wera", then macro looks into each column headers in sheet1 to find match, then it will copy all columns (header and data) and paste in in sheet2.
    Please take a look on the file that I've prepared. In real file there is much more columns and rows.

    Thanks,M.
    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. Returning the headers of all columns with a matching value
    By smohyee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2021, 06:33 PM
  2. Allocation of columns to other sheet based on matching headers
    By etaver87 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-24-2016, 09:44 AM
  3. Allocation of columns to other sheet based on matching headers
    By etaver87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2016, 09:41 AM
  4. macro to add columns after existing columns and copy/paste headers and formulas
    By rhybeka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2013, 02:35 PM
  5. [SOLVED] Search Multiple columns for string, display matching results on different sheet.
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 06:53 AM
  6. [SOLVED] Search Copy and Paste two columns in different sheet
    By mahtabshaikh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2012, 01:26 PM
  7. Auto filter multiple columns matching with searched headers
    By gotovamsee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2011, 03:20 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