+ Reply to Thread
Results 1 to 10 of 10

search & merge duplicate items based on inputbox

  1. #1
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 & 2016 insider(Windows 10 64-bit)
    Posts
    708

    search & merge duplicate items based on inputbox

    hello
    I have data in sheet entering , some data are duplicates . what I want when search for item based on column A by using inputbox , then should copy to sheet search and if the item are duplicate ,then should sum , merge . I put some results in sheets outcome1,2,3 how can be in sheet search when every time search for item . with considering any item have already copied to sheet search should not copy again .
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: search & merge duplicate items based on inputbox

    Try the attached file. Column A in the SEARCH sheet has a dropdown list of all the codes in the ENTERING sheet. Simply select a code from the drop down. If a duplicate code is selected, a message will pop up.
    Attached Files Attached Files
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: search & merge duplicate items based on inputbox

    Hi abdo meghari,

    Try below code ...

    Edit:"with considering any item have already copied to sheet search should not copy again" added one more line to cater for this

    Please Login or Register  to view this content.
    Last edited by nankw83; 03-27-2022 at 10:58 AM. Reason: Code adjustment
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  4. #4
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 & 2016 insider(Windows 10 64-bit)
    Posts
    708

    Re: search & merge duplicate items based on inputbox

    @Mumps thanks , but there is a problem.
    the item BSJ100 give value 44574 but the value should be 12 based on sheet ENTERING .

  5. #5
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 & 2016 insider(Windows 10 64-bit)
    Posts
    708

    Re: search & merge duplicate items based on inputbox

    @Mumps also the items should be 1,2,3 . the code seems copying the date as number.
    the code need arranging

  6. #6
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 & 2016 insider(Windows 10 64-bit)
    Posts
    708

    Re: search & merge duplicate items based on inputbox

    @nankw83 I will test your code and inform you how works.

  7. #7
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: search & merge duplicate items based on inputbox

    Try:
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 & 2016 insider(Windows 10 64-bit)
    Posts
    708

    Re: search & merge duplicate items based on inputbox

    @nankw83 fantastic ! thanks so much

  9. #9
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: search & merge duplicate items based on inputbox

    Try formatting column B in SEARCH as "Date".

  10. #10
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 & 2016 insider(Windows 10 64-bit)
    Posts
    708

    Re: search & merge duplicate items based on inputbox

    @Mump your code works except the column ITEM should be 1,2,3 , but it gives date as numbers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. adapting code to merge the quantity for two columns and for duplicate items
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2022, 01:58 AM
  2. [SOLVED] search data based on column by inputbox user and mark the cells in the same row
    By Mussa-A in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-07-2021, 11:29 AM
  3. Replies: 1
    Last Post: 11-03-2021, 10:40 AM
  4. [SOLVED] modified code merge duplicate items for each sheet separately based on this thread
    By KalilMe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-16-2021, 12:30 AM
  5. [SOLVED] update or change owner of code merge duplicate items for each sheet separately
    By Hasson in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-15-2021, 07:33 AM
  6. merge and unmerge duplicate items based on two options for each sheet
    By abdo meghari in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-21-2021, 08:51 PM
  7. [SOLVED] Combine rows with duplicate items in one cell and merge values in other cell
    By Niclal in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-18-2014, 07:04 AM

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