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 .
Bookmarks