+ Reply to Thread
Results 1 to 10 of 10

Macro - Data copy from one sheet to other according to the header name

  1. #1
    Registered User
    Join Date
    01-28-2015
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    32

    Macro - Data copy from one sheet to other according to the header name

    Hi Expert,

    Currently I have a data sheet
    1.png
    There is 5 columns in the "Data" sheet.

    I want to have a Macros to copy the data from "Data" sheet to "Report" sheet. It will follow my header in "Report" sheet to extract the data from "Data" Sheet
    For example: "Report" Sheet with header Name and Subject, the Macro can extract the data in
    Name Column from "Data" sheet to Name Column in "Report" sheet
    Subject Column from "Data" sheet to Subject Column in "Report" sheet
    2.png
    Once I change the header in "Report" sheet, the Macro can copy the data from "Data" Sheet accordingly.

    Marco Copy Data.xlsm

    Thanks for your help!!!!

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro - Data copy from one sheet to other according to the header name

    Hi Chocobo

    Try this
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    01-28-2015
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    32

    Re: Macro - Data copy from one sheet to other according to the header name

    Hi John,

    Thanks for your help!! Really appreciate!!
    If there is "Null" cell in the data, can the code modify to copy whole column?

    Chocobo

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro - Data copy from one sheet to other according to the header name

    Hi Chocobo

    Try this revised Code...
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-28-2015
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    32

    Re: Macro - Data copy from one sheet to other according to the header name

    Thanks for your help!!!

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro - Data copy from one sheet to other according to the header name

    You're welcome...glad I could help. Thanks for the Rep.

  7. #7
    Registered User
    Join Date
    12-31-2014
    Location
    HCM
    MS-Off Ver
    2007
    Posts
    8

    Re: Macro - Data copy from one sheet to other according to the header name

    Can you help me?
    Thanks for your help!!!
    Attached Files Attached Files

  8. #8
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro - Data copy from one sheet to other according to the header name

    Hi hacke.r

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

  9. #9
    Registered User
    Join Date
    12-31-2014
    Location
    HCM
    MS-Off Ver
    2007
    Posts
    8

    Re: Macro - Data copy from one sheet to other according to the header name

    hi Jaslake
    Sorry and thank you

  10. #10
    Registered User
    Join Date
    01-28-2015
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    32

    Re: Macro - Data copy from one sheet to other according to the header name

    Solved, thanks!
    Last edited by Chocobo; 03-09-2018 at 12:08 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] Based on Column Header find and copy data from one sheet to another
    By Sachy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-31-2014, 10:00 AM
  2. Copy data from header to header in consolidation sheet
    By Ignesh in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-12-2013, 04:10 AM
  3. Need macro to locate non-zero, non-header column entries then copy to other sheet
    By Steve Rutkey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2011, 07:11 PM
  4. Macro tweak to ignore header row. +macro to copy from one sheet to another
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-16-2011, 03:21 PM
  5. Copy Data from one sheet to another using header as key
    By nihitsk in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-24-2011, 06:45 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