View Full Version : Sum Unique items from Advanced Filter

11-09-2008, 01:37 AM
I used an Advanced Filter to get a list of Unique Items from Col F Sheet 1 and posted them to a column Y. Then copied it , column Y to Sheet 2

Now, how can I get a total of each of the unique items on each line in that column Y?.
I need to know if its possible & how to do this in VBA because I have 70 unique items from my sheet Page1.
I need to get a total for each one of them and put it on page 2
On Sheet 1 The catagories are in Col F and the Totals are in Col U
Any ideas?


Bob Phillips
11-09-2008, 03:09 AM
With Worksheets("Sheet2")

LastRow = .Cells(.Rows.Count, "Y").End(xlUp).Row
.Range("X2").Resize(LastRow-1).Formula = "=SUMIF(Sheet1!F:F,Y2,Sheet1!U:U)"
End With

11-15-2008, 06:04 PM

I took off for a while and did not see the responce. Will try the code.