+ 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 Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,586

    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 Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,586

    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 Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,586

    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 Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,586

    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)

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