+ Reply to Thread
Results 1 to 4 of 4

comare and copy

  1. #1
    smb2000user100
    Guest

    comare and copy

    Hello,

    I have two worksheets(1, 2). There are two columns (item code, description)
    in the two worksheets. I want to compare the item codes in the worksheet1 and
    worksheet2 then if the item codes are same in two worksheets, copy the
    description from worksheet1 to worksheet2 automatically. How can I do it ?
    Thank you!

    Best regards,
    --
    George

  2. #2
    Rowan
    Guest

    RE: comare and copy

    See Vlookup in excel help.

    Regards
    Rowan

    "smb2000user100" wrote:

    > Hello,
    >
    > I have two worksheets(1, 2). There are two columns (item code, description)
    > in the two worksheets. I want to compare the item codes in the worksheet1 and
    > worksheet2 then if the item codes are same in two worksheets, copy the
    > description from worksheet1 to worksheet2 automatically. How can I do it ?
    > Thank you!
    >
    > Best regards,
    > --
    > George


  3. #3
    Myrna Larson
    Guest

    Re: comare and copy

    Let's assume your item codes are in column A on both worksheets, and you have
    descriptions in column B in the 1st worksheet only.

    In the 2nd worksheet, column B, put this formula

    =VLOOKUP(A2,Sheet1!$A$2:$B$1000,2,0)

    and copy it down. That assumes you have 1000 rows filled on Sheet1. Adjust the
    references to suit.

    To convert those formula to their values, Edit/Copy the column of formulas,
    then, without changing the selection, Edit/Paste Special and select the Values
    option.

    On Thu, 21 Apr 2005 13:08:06 -0700, "smb2000user100"
    <smb2000user100@discussions.microsoft.com> wrote:

    >Hello,
    >
    >I have two worksheets(1, 2). There are two columns (item code, description)
    >in the two worksheets. I want to compare the item codes in the worksheet1 and
    >worksheet2 then if the item codes are same in two worksheets, copy the
    >description from worksheet1 to worksheet2 automatically. How can I do it ?
    >Thank you!
    >
    >Best regards,



  4. #4
    smb2000user100
    Guest

    Re: comare and copy

    It works. Thank you very much!

    "Myrna Larson" wrote:

    > Let's assume your item codes are in column A on both worksheets, and you have
    > descriptions in column B in the 1st worksheet only.
    >
    > In the 2nd worksheet, column B, put this formula
    >
    > =VLOOKUP(A2,Sheet1!$A$2:$B$1000,2,0)
    >
    > and copy it down. That assumes you have 1000 rows filled on Sheet1. Adjust the
    > references to suit.
    >
    > To convert those formula to their values, Edit/Copy the column of formulas,
    > then, without changing the selection, Edit/Paste Special and select the Values
    > option.
    >
    > On Thu, 21 Apr 2005 13:08:06 -0700, "smb2000user100"
    > <smb2000user100@discussions.microsoft.com> wrote:
    >
    > >Hello,
    > >
    > >I have two worksheets(1, 2). There are two columns (item code, description)
    > >in the two worksheets. I want to compare the item codes in the worksheet1 and
    > >worksheet2 then if the item codes are same in two worksheets, copy the
    > >description from worksheet1 to worksheet2 automatically. How can I do it ?
    > >Thank you!
    > >
    > >Best regards,

    >
    >


+ 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