Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would like the excel spread sheet i created to do the following:
Ive created an excel spreadsheet using simple =sum(cell) commands for the purpose of a personal budget.. And i would like upon opening of this spreadsheet for firstly it to ask the following, so when i type my amount into an amounts box it will use the correct cell position. All 3 questions that follow would be on the one page, with an option to add another expense entry onto the spreadsheet, or finish & save, then goto view the budget. 1) Be able within a drop menu select the heading (EG entertainment or House & Garden etc) so it selects the correct "column" for the amount which will be entered in Q:3. 2) Then, Select a date from a drop menu so that it selects the correct "row" so that when i enter the amount spent on this day for the particular expense it selects the correct cell. that Q:3 refers to. 3) Then, have an entry box which would have been referenced by the previous selections so that the amount i type into it will be correctly placed onto the spreadsheet. according to colun and row. After entered.. when pressing on add another expense it saves the amount onto the field... then blanks the previous options selected so a new criteria can be entered in and saved... etc etc. This surely is possible.. ive spent money to try and learn this but im just getting no-where.. Please help me if you can.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Step by Step | Excel Discussion (Misc queries) | |||
Need step by step instructions to try, not a demo. Can't remember | Excel Worksheet Functions | |||
Need step by step instructions to try, not a demo. Can't remember | Excel Worksheet Functions | |||
FRUSTRATED!!! COMBO BOX AND PROGRAMMING IT | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |