creating an "interface-table" into 1 cell

[Mario]

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]

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.

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