Results 1 to 4 of 4

Find excel column and copy to other sheet

This is a discussion on Find excel column and copy to other sheet within the Excel Questions forums, part of the Question Forums category; I need to find by title some columns in one sheet and copy these columns one after the other to ...

  1. #1
    Board Regular
    Join Date
    Apr 2006
    Location
    Latvia
    Posts
    223

    Default Find excel column and copy to other sheet

    I need to find by title some columns in one sheet and copy these columns one after the other to other sheet.
    How to made by VBA?

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    27,239

    Default Re: Find excel column and copy to other sheet

    Can you give more details?
    What titles are you looking for?
    What are your sheet names?
    Are you copying them to the exact same column on the other sheet (if not, there how to determine which column to paste to)?
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular
    Join Date
    Apr 2006
    Location
    Latvia
    Posts
    223

    Default Re: Find excel column and copy to other sheet




    Prod. Order No.Item No.Item NameQuantityStarting DateEnding DateFinished DateStatusOutst. QuantityStart Week
    O00014  004.04.201104.04.2011  014
    11-S0137-0031-82-000aaaaa128.06.201129.06.2011  126
    11-S0237-0001-32-12Abbbbb128.06.201129.06.2011  126
    11-S0336-4274-01-000ccccc128.06.201129.06.2011  126
    11-S0436-4276-01-000ddddd128.06.201129.06.2011  126
    11-TEX15836-4703-BG-000eeeee1002.03.201104.03.201107.03.2011Finished09


    For example table like this and i need to copy to other sheet columns with title - Prod. Order No., Item No., Ending Date, Status.
    .
    ,
    ,

  4. #4
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    27,239

    Default Re: Find excel column and copy to other sheet

    The easiest thing to do might be to copy the whole table over, then delete the columns you do not need.
    If you use the Macro Recorder, you should be able to record most of the code you need to do this.
    If you need help cleaning up the code afterwards, or adding things to it, post the code you have here with your request.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com