+ Reply to Thread
Results 1 to 13 of 13

update or change owner of code merge duplicate items for each sheet separately

  1. 09-20-2021, 06:16 AM #1
    Hasson
    Hasson is offline
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    210

    update or change owner of code merge duplicate items for each sheet separately

    hi
    when I search for like my thread , accidently i've foun this thread https://www.excelforum.com/excel-pro...-column.htmlmr. Jindon and Bo_Ry have solved but in my case I would apply the codes for each sheet separatelyi desighn the simple data like what is exiseted in the thread with a bit different but the range is the same . when run the macro should merge all duplicate items in each sheet separately.
    so should merge duplicate items based on COL B for each sheet seperatly .
    about COL H should sum but COL I should calculate price averege because it changes , COL J should equal COL H X COL I
    I put the result in three sheets(result1,result2,result3) . should merge sheet separately
    with considering my real data are big and every time I create new sheets so I want the code more flexible
    I hope owner's codes see my request
    thanks in advance
    Attached Files Attached Files
    Last edited by Hasson; 09-22-2021 at 07:47 AM.
    Reply With QuoteRegister To Reply
  2. 09-22-2021, 08:23 AM #2
    Hasson
    Hasson is offline
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    210

    Re: update or change owner of code merge duplicate items for each sheet separately

    can anybody help?
    Reply With QuoteRegister To Reply
  3. 09-22-2021, 09:50 AM #3
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: update or change owner of code merge duplicate items for each sheet separately 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 09-22-2021, 10:04 AM #4
    Hasson
    Hasson is offline
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    210

    Re: update or change owner of code merge duplicate items for each sheet separately

    great work ! thanks so much .
    just curiosity . can I merge in the same sheet for each sheet separately
    I mean there is no sheets result just merge in( AB1,AD1,JGG-12)
    thanks for your help
    Reply With QuoteRegister To Reply
  5. 09-22-2021, 10:20 AM #5
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: update or change owner of code merge duplicate items for each sheet separately

    I don't understand what you are asking.

    Upload a workbook with EXACT result that you want.
    Reply With QuoteRegister To Reply
  6. 09-22-2021, 10:27 AM #6
    Hasson
    Hasson is offline
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    210

    Re: update or change owner of code merge duplicate items for each sheet separately

    each sheet separately should merge alone . I put the result in each sheet after run macro based on original file in OP
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 09-22-2021, 10:37 AM #7
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: update or change owner of code merge duplicate items for each sheet separately

    Change to
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 09-22-2021, 11:17 AM #8
    Hasson
    Hasson is offline
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    210

    Re: update or change owner of code merge duplicate items for each sheet separately

    excellent ! much appreciate
    Reply With QuoteRegister To Reply
  9. 10-14-2021, 12:16 PM #9
    KalilMe
    KalilMe is offline
    Forum Contributor
    Join Date
    04-11-2021
    Location
    Tripoli
    MS-Off Ver
    Excel 2016 ,windows 10 64bit
    Posts
    345

    Re: update or change owner of code merge duplicate items for each sheet separately

    @jindon I follow your code in post#3 . it seems sreach the sheets contain sheet name RESULT when show the result in sheets(result, result1,result2 ) but my sheets names are (report,export,import) how can I mod this line
    HTML Code: 
    to adapt based on my sheets names which show the result in them . can you guide me ,please?
    Reply With QuoteRegister To Reply
  10. 10-14-2021, 10:43 PM #10
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: update or change owner of code merge duplicate items for each sheet separately 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 10-15-2021, 06:30 AM #11
    KalilMe
    KalilMe is offline
    Forum Contributor
    Join Date
    04-11-2021
    Location
    Tripoli
    MS-Off Ver
    Excel 2016 ,windows 10 64bit
    Posts
    345

    Re: update or change owner of code merge duplicate items for each sheet separately

    @jindon thanks . it gives mismatch
    HTML Code: 
    Reply With QuoteRegister To Reply
  12. 10-15-2021, 06:31 AM #12
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: update or change owner of code merge duplicate items for each sheet separately

    Now you MUST open a new thread.
    Reply With QuoteRegister To Reply
  13. 10-15-2021, 07:33 AM #13
    KalilMe
    KalilMe is offline
    Forum Contributor
    Join Date
    04-11-2021
    Location
    Tripoli
    MS-Off Ver
    Excel 2016 ,windows 10 64bit
    Posts
    345

    Re: update or change owner of code merge duplicate items for each sheet separately

    @ thanks jindon I will do
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. [SOLVED] Extract and return a distinct and duplicate items list separately from a two list items
    By Mohammad Munawar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-14-2020, 07:42 AM
  3. [SOLVED] Saving Invoice for each items separately
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-14-2017, 01:11 PM
  4. vba code to update all pivot tables based on cell change on active sheet only
    By seatejo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2014, 08:34 PM
  5. I need a VBS code that change a phone number to the name of the owner
    By zitno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2014, 04:47 PM
  6. update value and edit items already update on sheet by userform
    By tjxc32m in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-08-2013, 10:13 AM
  7. [SOLVED] update "master sheet" with project name, date, owner
    By rickmeister in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2013, 08:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1