+ Reply to Thread
Results 1 to 6 of 6

Based on Column Header find and copy data from one sheet to another

  1. #1
    Registered User
    Join Date
    02-07-2013
    Location
    Slovakia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Based on Column Header find and copy data from one sheet to another

    Hello, I am looking for some easiest way how to do the following: 1) Find Column1 Header on sheet1, 2) Select all data from that column (Without Header to last used cell), 3) Copy this selection, 4) Find Column2 Header on sheet2, 5) Paste data below it

    I have put together code that can do it but it seems very long to me and I now there is definitely a better way how to do that , so I will be thankful for any advice how to make it simpler, because then I can use it for more columns without having 1km of code

    Please Login or Register  to view this content.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Based on Column Header find and copy data from one sheet to another

    Try this:

    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    02-07-2013
    Location
    Slovakia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Based on Column Header find and copy data from one sheet to another

    Thanks for your reply, it was not exactly what I needed (while Headers aren't same on both sheets), but you point me in right way and with little utilizing it makes exactly what I want. And also the code looks better to me as the previous I have, thanks to you JBeaucaire - good job!

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Based on Column Header find and copy data from one sheet to another

    Glad to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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