simora
11-09-2008, 01:37 AM
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
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