Hello guys,
i have used Autofilter after the help of you guys, and thanks for that.

Now i have another issue. I have 2 worksheets. In one (Stocks) i have the
table which i use the Autofilter.
In the other worksheet i will have the Summary of the results. However this
is the problem for me now....
In the A column i have the weeks. In the comlumn B i have the companies, and
in column C i have the values/numbers.
Now i want to select in the 'Stocks' worksheet one specific week.
Is there a way to have as a summary afterwards, in the other workshet, what
has come up in Column B ? Sometimes the same company might come a lot of
times in one week. Is there a way to summarise these in order to show in the
'Summary' worksheet, just one time a company that has come up many times in
that week, and the Sum of all of its values?

thanks in advance, i hope you have understood what am i doing....

Haris.