creating an "inferface-table" into one cell

  • Thread starter Thread starter Mario
  • Start date Start date
M

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
 
Mario,

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

HTH,
Bernie
MS Excel MVP
 
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
 
Hi Mario,
A cell cannot contain a table or worksheet.
You may get a usable solution with Data>Group & Outline.
 
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
 
Back
Top