+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Copy row (e.g column A to Z) to next column (e.g column E) in another sheet

  1. #1
    Registered User
    Join Date
    01-25-2011
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Copy row (e.g column A to Z) to next column (e.g column E) in another sheet

    Hi, I'm newbie in this forum and also in Excel. I need your help..

    I have this case :
    I would like to copy row in sheet 2 to column D (as starting point) in sheet 1 if value in column C in sheet 2 matches value in column A in sheet 1.

    The value is flexible, but in number format.

    So it's like merging 2 sheet with different number of cases/rows "

    Sheet 1

    Column
    A B C D E F, etc....
    Row 11234 xxx xx
    2 2312 yyy dd
    3 2123 zzz aa
    4 1112 ddd ee


    Sheet 2

    Column
    C D E F,etc....
    Row 1 8321 sss
    2 1234 fff
    3 1314 ggg
    4 2312 hhh
    5 2123 qqq
    6 1424 www
    7 5252 yyy
    8 1112 ppp



    Please help me. Thank you so much
    Last edited by kope; 01-26-2011 at 12:36 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