Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 22nd 05, 05:02 PM
grassfed
 
Posts: n/a
Default Is there way to enter multiple values into excel cells w/ a form?

I have multiple years of linked excel spreadsheets that contain our cash flow
and projections so I can't change my general excel format but what I need to
learn is:

Is there a way to enter values into some other sort of "form" that will send
it to a certain designated cell. What I do is enter each penny we spend and
it goes into the monthly (column) by the category (row). Also shown is all
our income by the same method, all on the same sheet. What ends up
happening is that I end up having many, many dollar/cent figures all
connected by plus signs in each cell and if anything goes wrong {computer
locks up, ect.} I loose all the other values I have put in earlier for that
month with no way to fix unless I just start over going through every
receipt, etc. I should think I could create some form that would have
dropdowns for each month and category and when I entered the dollars/cents
and hit "enter" that they would then add to that cell. ?

When I start the year, the cell values are calculated by an average of the
past several years based upon our current inventory (another excel) and
thereby create a "cash flow projection" and as I enter each month's dollars,
I change them to actual dollars.

We have very different accounts etc so I can't find any canned programs that
work -- I really need to create this.

PLEASE HELP!!

  #2   Report Post  
Old June 22nd 05, 05:26 PM
JPW
 
Posts: n/a
Default

It is certainly possible with some creative VBA programming that breaks up your cell formulas as you go. Sounds like quite a mess to
me, wish you would've used Access instead! If you want a working solution you'll have to either give some more detail with
examples or send an example file to my e-mail (make sure you type "MSEXCEL" in the subject line and take the "REMOVE" out of the
address). Before doing the latter, make sure your organization doesn't have policy against releasing such information.

"grassfed" wrote in message ...
I have multiple years of linked excel spreadsheets that contain our cash flow
and projections so I can't change my general excel format but what I need to
learn is:

Is there a way to enter values into some other sort of "form" that will send
it to a certain designated cell. What I do is enter each penny we spend and
it goes into the monthly (column) by the category (row). Also shown is all
our income by the same method, all on the same sheet. What ends up
happening is that I end up having many, many dollar/cent figures all
connected by plus signs in each cell and if anything goes wrong {computer
locks up, ect.} I loose all the other values I have put in earlier for that
month with no way to fix unless I just start over going through every
receipt, etc. I should think I could create some form that would have
dropdowns for each month and category and when I entered the dollars/cents
and hit "enter" that they would then add to that cell. ?

When I start the year, the cell values are calculated by an average of the
past several years based upon our current inventory (another excel) and
thereby create a "cash flow projection" and as I enter each month's dollars,
I change them to actual dollars.

We have very different accounts etc so I can't find any canned programs that
work -- I really need to create this.

PLEASE HELP!!





Reply
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
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Multiple X-Axis Values Rob Herrmann Charts and Charting in Excel 2 January 23rd 05 10:57 PM
Enter Data Into Another Excel File Automatically Morrisg Excel Worksheet Functions 0 January 11th 05 02:07 AM
Sum with multiple conditions in Excel 2000 Magnus Oskarsson Excel Worksheet Functions 2 December 16th 04 04:09 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 02:39 AM


All times are GMT +1. The time now is 07:43 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017