View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mario[_5_] Mario[_5_] is offline
external usenet poster
 
Posts: 7
Default creating an "inferface-table" into one cell

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