There's a couple of things that are built into excel that are kind of close.
If you put your categories on each row, you can do Data|Subtotal to get your
total for each category. There are outlining symbols to the left of the row
numbers that allow you hide the details--so you only see the subtotals.
Another way is to use Data|Group. This would be more of a manual effort, but
you may like it better (if your data is already entered in a format that
Data|Subtotal doesn't like). This also has the outlining symbols.
And finally, you could look at Data|pivot tables. You'd still want to have the
category on each row, but then you could actually double click on the subtotal
in the pivottable and a new sheet will be created that includes just those
things that were in that subtotal.
Mario wrote:
>
> hi, my problem is a bit complicate so i hope u can understand:
>
> i have a xls table an in 1 cell (B3) i have an integer, so i want if u
> click on that special cell B3 that there opens a "new" small table
>
> for example [B2] "needed material for project 2003.1234" - [B3] "345",
> so B3 consists of
> +100
> +100
> -10
> +100
> -40
> -5.
> ...
> _____
> =345
> =====
>
> how to do this? please give me a tip i really need to solve this problem
> quickly and in an easy way, i know a bit about makros and i (think) im good
> in excel but i dont want to change this formular into an accsess table
> becaus the project managers need to use xls
>
> tks and kind regards
> mario
--
Dave Peterson
(E-Mail Removed)
Similar Threads
