+ Reply to Thread
Results 1 to 8 of 8

Copy and combining duplicate data

  1. #1
    Registered User
    Join Date
    05-29-2021
    Location
    Lebanon Junction, Ky.
    MS-Off Ver
    2016
    Posts
    11

    Copy and combining duplicate data

    I am trying to extract certain data from sheet2 and enter into sheet1. Is there a way to do this with a formula or macro so that when new data is entered in sheet2 it will update sheet1?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    18,418

    Re: Copy and combining duplicate data

    It could be done with a macro. How many customers?

    I suspect (know?) the example is an over-simplification: how do "ECI Mon" (Sheet1) relate to "#ECI s" (Sheet2) as "ECI Mon" appears to be the month number?

  3. #3
    Registered User
    Join Date
    05-29-2021
    Location
    Lebanon Junction, Ky.
    MS-Off Ver
    2016
    Posts
    11

    Re: Copy and combining duplicate data

    Not sure how many customers, it constantly changing. I do know it is over 100. ECI Month is the same on sheet 2. The yellow highlighted areas on sheet 2 is the info I am trying to use.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    18,418

    Re: Copy and combining duplicate data

    Column D in Sheet1 has "# ECI s": does this count refer to column C ("ECI Seq") in Sheet1 ?

    Is the data sorted? If not, can it be ?

    And would the layout in "Sample" of attached be better?
    Attached Files Attached Files
    Last edited by JohnTopley; 06-11-2021 at 11:20 AM.

  5. #5
    Registered User
    Join Date
    05-29-2021
    Location
    Lebanon Junction, Ky.
    MS-Off Ver
    2016
    Posts
    11

    Re: Copy and combining duplicate data

    Column D in sheet1 refers to how many times a "customer" appears in the list per month. If a customer is listed twice in January I want to report as 1 row and sum the cost. the number of ECIs will indicate they were in there twice. The sample would be fine.

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    18,418

    Re: Copy and combining duplicate data

    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-29-2021
    Location
    Lebanon Junction, Ky.
    MS-Off Ver
    2016
    Posts
    11

    Re: Copy and combining duplicate data

    Thanks. I will look look at it Monday when I go back to the office.

  8. #8
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    18,418

    Re: Copy and combining duplicate data

    Add updated changes including TOTAL line(plus some cosmetic!)
    Attached Files Attached Files

+ 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] Combining Duplicate Header data
    By Naveed Raza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2020, 01:52 PM
  2. Combining Column Data When There are Duplicate Row Headers
    By Jhmman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2014, 09:44 PM
  3. [SOLVED] Combining rows with both unique and duplicate data
    By CNFlora in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2013, 05:09 PM
  4. Combining data from duplicate values?
    By mikemeadeuk in forum Excel General
    Replies: 0
    Last Post: 12-13-2010, 07:47 AM
  5. Combining Rows With Duplicate Data
    By Jaricketts in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2010, 01:21 PM
  6. Combining duplicate companies and data
    By Watchdog in forum Excel General
    Replies: 2
    Last Post: 03-27-2008, 08:32 PM
  7. Combining Multiple Fields with Duplicate Data
    By rechewjr in forum Excel General
    Replies: 1
    Last Post: 03-11-2008, 09:12 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