LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Can anyone povide step by step instructions on how to do the follo

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Step by Step fak119 Excel Discussion (Misc queries) 2 August 31st 06 08:11 AM
Need step by step instructions to try, not a demo. Can't remember [email protected] Excel Worksheet Functions 1 June 15th 06 09:24 PM
Need step by step instructions to try, not a demo. Can't remember [email protected] Excel Worksheet Functions 0 June 15th 06 10:05 AM
FRUSTRATED!!! COMBO BOX AND PROGRAMMING IT Russell-stanely Excel Discussion (Misc queries) 6 July 7th 05 09:19 PM
I need step by step instructions to create a macro for 10 imbedde. diana Excel Worksheet Functions 3 January 31st 05 01:56 AM


All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"