creating an "inferface-table" into one 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

 

[Bernie Deitrick]

Mario,

What rules do you apply to get the 100, 100, ....?

HTH,
Bernie
MS Excel MVP

 

[Mario]

hmm
the perfect solution would be that if u do doubble click on B3 a
"new-small-tiny-excel" opens and that u can type in there
A
1 100
2 20
3 -10
4 -15

and that B3 than has the vaule 95
the problem is that tere could be 20-30 of these B-fields so a connection to
another table is tooo complicate
u understand the problem?

kind regards
mario

 

[jaf]

Hi Mario,
A cell cannot contain a table or worksheet.
You may get a usable solution with Data>Group & Outline.

 

[Bernie Deitrick]

Mario,

You could use a userform to allow a user to enter numbers into a text
box that are then summed with the sum placed into the cell. Would
that work?

Otherwise, just have the user start type

=100+20-15-10

and Excel will evaluate the formula that results to show 95.

HTH,
Bernie
MS Excel MVP