Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alert messages, running totals, connecting spreadsheets or cells
I need to be able to generate alert messages based on the result of a
calculation. I'll use the example of a checkbook and bank statement balance to explain what I'd like to do. I need to be able to calculate running totals, for example, as you would with your check book and that running total needs to be connected to another spreadsheet or another cell on the same spreadsheet (for example a bank statement running total). Also I need to connect the two spreadsheets or areas of the spreadsheet, so that if I enter an amount in the checkbook, it is reconciled with the bank statement balance. I need to calculate total outstanding checks, and final checkbook balance and final bank statement balance (& difference if they are out of balance) and then generate either Out of Balance or Good Balance alerts. I would appreciate any help. thank you. -- Cheryl |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alert messages, running totals, connecting spreadsheets or cells
Chreryl
result in a1 = BoKu Bucks qualifier in b1 = if(a1="BoKu Bucks",1,"") Alert notification in c1 = if(b1=1,"Alert: You have BoKu Bucks. Share the Wealth! I'm a socialist, I can't help it.","") You could eliminate the c1 and just put it in b1, but I have found that I frequently go back and concatenate() various messages as I go along because you want to alert them for more than one thing. You want the alert near the qualifier so the see it immediately, but you may be calculating over a1:au10000. That makes it difficult to see any errors down there if your at the top. God Bless Frank Pytel "cheryl" wrote: I need to be able to generate alert messages based on the result of a calculation. I'll use the example of a checkbook and bank statement balance to explain what I'd like to do. I need to be able to calculate running totals, for example, as you would with your check book and that running total needs to be connected to another spreadsheet or another cell on the same spreadsheet (for example a bank statement running total). Also I need to connect the two spreadsheets or areas of the spreadsheet, so that if I enter an amount in the checkbook, it is reconciled with the bank statement balance. I need to calculate total outstanding checks, and final checkbook balance and final bank statement balance (& difference if they are out of balance) and then generate either Out of Balance or Good Balance alerts. I would appreciate any help. thank you. -- Cheryl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connecting data between 2 spreadsheets | Excel Worksheet Functions | |||
running totals | Excel Discussion (Misc queries) | |||
Connecting Linked Spreadsheets | Excel Discussion (Misc queries) | |||
Removing some alert messages | Excel Discussion (Misc queries) | |||
How to hide unused cells when running accumulated totals | Excel Worksheet Functions |