+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : HELP- Find Existing Duplicate in Column C and then copy Contents from Adjacent Cell in D

  1. #1
    Registered User
    Join Date
    03-28-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    HELP- Find Existing Duplicate in Column C and then copy Contents from Adjacent Cell in D

    Hello,

    I have a list of products with lot numbers. Sometime we get additional products from the same lot number.
    The lot numbers are entered into column C.
    If the received product is same as we received before (according to the lot No. in C), I need excel to copy contents of from corresponding cell in column D into a corresponding cell again in column D.
    I hope it is clear enough to provide me with some advice.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: HELP- Find Existing Duplicate in Column C and then copy Contents from Adjacent Cell in

    A sample workbook with sample data would help.

    So when a product of the same lot comes in, you want to adjust your quantity instead of listing it as another product? I get it. It pretty much has to be done by macros.

    There are two ways to implement this. Either on the input side(as products are added to the list) or after the duplicate product/lot already exist on the database.

  3. #3
    Registered User
    Join Date
    03-28-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: HELP- Find Existing Duplicate in Column C and then copy Contents from Adjacent Cell in

    I am looking to do it on the input side. Thank you!

+ 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