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

"Mario" wrote in message
y.telekom.at...
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

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 DataGroup & Outline.



--

John

johnf202 at hotmail dot com


"Mario" wrote in message
y.telekom.at...
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

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

"Mario" wrote in message
y.telekom.at...
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