Find excel column and copy to other sheet

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Find excel column and copy to other sheet

  1. #1
    Board Regular
    Join Date
    Apr 2006
    Location
    Latvia
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    42,657
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    1 Thread(s)

    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
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    42,657
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    1 Thread(s)

    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!"

User Tag List

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