Sum Unique items from Advanced Filter

[simora]

Hi:
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?

Thanks

[Bob Phillips]

[VBA]

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
[/vba]

[simora]

Thanks:

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