Hi

A Pivot Table will do this better, faster, without code. Give it half an
hour, you won't believe how anyone can work without pivot tables afterwards:

http://chandoo.org/wp/2009/08/19/exc...bles-tutorial/
http://www.howtogeek.com/howto/13336...bles-in-excel/

HTH. Best wishes Harald


skrev i melding
...
Hi,

I need some help. I am trying to filter the data by unique value in the
column and copy paste it to the different sheet like a groups.

ex:- I have data like this

Item1 Item2 Sales
Group1 1 $10
Group1 2 $20
Group1 3 $20
Group2 1 $20
Group2 1 $30
Group3 1 $10
Group3 1 $15

I want the data should look like this

Group 1

Item2 Sales
1 $10
2 $20
3 $20

Group 2

Item2 Sales
1 $20
1 $30

Group 3
Item2 Sales
1 $10
1 $15

Please help me how can we do that.