Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
Reference to cells using autofilter problem | Excel Worksheet Functions | |||
Autofilter - on select columns | Excel Worksheet Functions | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Why aren't my cells highlighted when I select multiple cells? | Setting up and Configuration of Excel |