+ Reply to Thread
Results 1 to 6 of 6

Merge amounts for each duplicates tranfer number separately & paste data to Master sheet

  1. 11-02-2023, 01:06 AM #1
    zameel
    zameel is offline
    Registered User
    Join Date
    06-24-2009
    Location
    Maldives
    MS-Off Ver
    MS 365 Subscription, v.2308
    Posts
    14

    Post Merge amounts for each duplicates tranfer number separately & paste data to Master sheet

    What I am trying to do is:
    - To look at column I and if duplicated columns with the same number appears, it needs To merge the data for coloumn A and J.
    - The contact numbers to be appear same, it means colomun D some numbers having space and dash between the numbers to be removed.
    - Add a coloumn to Master sheet to last and total the value of merged data on coloum J
    - After finish I want copy daily data to Master sheet of available last row, so that I can keep the all data in one sheet.
    I have given a result sample in the Master sheet for easier to understand.
    Any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by zameel; 11-02-2023 at 06:06 AM. Reason: solved
    Reply With QuoteRegister To Reply
  2. 11-02-2023, 05:07 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Merge amounts for each duplicates tranfer number separately & paste data to Master she 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 11-02-2023, 05:26 AM #3
    zameel
    zameel is offline
    Registered User
    Join Date
    06-24-2009
    Location
    Maldives
    MS-Off Ver
    MS 365 Subscription, v.2308
    Posts
    14

    Re: Merge amounts for each duplicates tranfer number separately & paste data to Master she

    Excellent! It's working as i mentioned in the sample but a small thing you missed.
    In coloumn D there is space and "-" between some contact numbers, i want to remove these dash and spaces between the number.
    can you help me? Other than every thing works super. Thank you.
    Reply With QuoteRegister To Reply
  4. 11-02-2023, 05:39 AM #4
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Merge amounts for each duplicates tranfer number separately & paste data to Master she

    ,,, Sorry .. "forgot" about column D

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 11-02-2023, 06:03 AM #5
    zameel
    zameel is offline
    Registered User
    Join Date
    06-24-2009
    Location
    Maldives
    MS-Off Ver
    MS 365 Subscription, v.2308
    Posts
    14

    Re: Merge amounts for each duplicates tranfer number separately & paste data to Master she

    Excellent, Thank you.
    Reply With QuoteRegister To Reply
  6. 11-02-2023, 06:06 AM #6
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Merge amounts for each duplicates tranfer number separately & paste data to Master she

    Please mark as SOLVED : "Thread Tools" at top of page.

    Thank you for the rep.
    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. [SOLVED] merge amounts for each duplicates dates separately
    By Maklil in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-14-2023, 02:38 PM
  2. [SOLVED] how implement this code to merge data for each sheet separately instead of repeating code
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 50
    Last Post: 06-26-2023, 03:09 PM
  3. [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
  4. [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
  5. Tranfer data to another sheet
    By 209dude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-15-2015, 05:45 PM
  6. Tranfer data to another sheet
    By 209dude in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2015, 07:59 PM
  7. Merge All Sheets Data Into Master Sheet Based on a condition
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2012, 05:24 AM

Tags for this Thread

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