Select cells after Autofilter
 

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.

Select cells after Autofilter
 

So i suppose this is not possible....

I should change the worksheet then and demand less things :-)

"Haris" wrote:

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.

Select cells after Autofilter
 

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 :-)
------------------------------*------------------------------*----------------


"Haris" wrote in message
...
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.