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?

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?

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.

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.

Please Login or Register  to view this content.

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

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

This is what I am looking for. Is there a way to generate a report for each department (Originating Department)? The first sheet I had attached was for one dept. I was using a Macro that I had found but it does not update the data whenever I receive new data each week. I am attaching the original spreadsheet. Sorry for the confusion.

If that is possible.

It would appear you defined Table 1 as having "No header" so row 1 is sorted as data. I was planning to sort by "Originating Department" to make processing easier.

I believe that will work.

Please Login or Register  to view this content.

Data is copied to and sorted by Dept/Custpmer in sheet "Work".

I also added sheet "Pivot" which is pivot table analysis - and I am no expert in PTs; if acceptable removes the need for the VBA.

Looks good. I appreciate your help.