Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
Can you make a cell = 0 if original function is creating a"#ref!"? | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |