Select cells after Autofilter

[Haris]

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.

 

[Haris]

So i suppose this is not possible....

I should change the worksheet then and demand less things

 

[Ken Wright]

Have you tried looking at Pivot tables. A sheet of source data in tabular
format and a requirement for a summary table, can often be solved very very
easily with a Pivot table. Even if your current data structure doesn't fit
the requirements of a PT right now, it may well be worth considering a
change to be able to realise the benefits that a PT can bring.

An excellent introduction to Pivot tables
http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------