+ Reply to Thread
Results 1 to 13 of 13

add new file & merge duplicate item for each sheet alone

  1. #1
    Forum Contributor
    Join Date
    04-11-2021
    Location
    TRI
    MS-Off Ver
    OFFICE2016
    Posts
    182

    add new file & merge duplicate item for each sheet alone

    Hi Guys
    I have many sheets contains duplicate items , what I want merging duplicate items for each sheet alone( not across sheets ) based on column C . as to summing values should just be the columns QTY,TOTAL and should ignores columns DATE(should replace of it numbers 1,2,3) , ORDER,PRICE when merging should be as in the result in file RESULT .
    note: this is simple data , but my real for each sheet could be 2000 rows .
    thanks
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,052

    Re: add new file & merge duplicate item for each sheet alone

    add new file & merge duplicate item for each sheet alone
    Quote Originally Posted by KalilMe View Post
    I want merging duplicate items for each sheet alone( not across sheets ) based on column C . as to summing values should just be the columns QTY,TOTAL and should ignores columns DATE(should replace of it numbers 1,2,3) , ORDER,PRICE when merging should be as in the result in file RESULT .
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-11-2021
    Location
    TRI
    MS-Off Ver
    OFFICE2016
    Posts
    182

    Re: add new file & merge duplicate item for each sheet alone

    awesome !!
    can I do that without select the file from browser,please?
    just I put the macro in file COLLECTION and when run it add new file RESULT
    thanks

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,052

    Re: add new file & merge duplicate item for each sheet alone

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    04-11-2021
    Location
    TRI
    MS-Off Ver
    OFFICE2016
    Posts
    182

    Re: add new file & merge duplicate item for each sheet alone

    thanks but isn't like the orginal code . the code ignores column Total and not ignore column PRICE when merge

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,052

    Re: add new file & merge duplicate item for each sheet alone

    Mistook of column references.
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    04-11-2021
    Location
    TRI
    MS-Off Ver
    OFFICE2016
    Posts
    182

    Re: add new file & merge duplicate item for each sheet alone

    it gives error #REF in column TOTAL in file RESULT .

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,052

    Re: add new file & merge duplicate item for each sheet alone

    Upload the workbook with the code that is giving you such error.

  9. #9
    Forum Contributor
    Join Date
    04-11-2021
    Location
    TRI
    MS-Off Ver
    OFFICE2016
    Posts
    182

    Re: add new file & merge duplicate item for each sheet alone

    here is the file
    Attached Files Attached Files

  10. #10
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,052

    Re: add new file & merge duplicate item for each sheet alone

    OK, add one line in bold.
    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    04-11-2021
    Location
    TRI
    MS-Off Ver
    OFFICE2016
    Posts
    182

    Re: add new file & merge duplicate item for each sheet alone

    thanks again
    there is too strange case in sheets ("STA","RPA") . it gives wrong values for duplicates items into column (TOTAL) after combining .
    I highlighted the wrong values and put the right value beside it in column H .
    Attached Files Attached Files

  12. #12
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,052

    Re: add new file & merge duplicate item for each sheet alone

    Look at your RESULT.xlsm in your initial post.

    G2 in STA is showing as TRY 8,400.00, so I just did it.
    Add 2 lines
    Please Login or Register  to view this content.

  13. #13
    Forum Contributor
    Join Date
    04-11-2021
    Location
    TRI
    MS-Off Ver
    OFFICE2016
    Posts
    182

    Re: add new file & merge duplicate item for each sheet alone

    Look at your RESULT.xlsm in your initial post.

    G2 in STA is showing as TRY 8,400.00, so I just did it.

    I'm really sorry about it .
    thanks very much for everything .

+ 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. [SOLVED] how add function average to the this code and merge duplicate item?
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-09-2021, 02:38 PM
  2. [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
  3. [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
  4. 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
  5. [SOLVED] VBA To populate listbox with duplicate item by increasing the item quantity
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-01-2016, 07:51 AM
  6. [SOLVED] open the csv file and merge them into sheet
    By dolphino in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-16-2015, 02:56 AM
  7. [SOLVED] Merge excel sheets from one file within one sheet
    By rmn19 in forum Excel General
    Replies: 9
    Last Post: 07-17-2012, 08:23 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