Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Input dollar amount into a cell that updates another cell and more
Help!
I am racking my brain trying to figure out how to input a dollar figure into a cell (A1)that updates another cell (A2) with the running total (easy to do) but the hard part is when you want to add in the next dollar figure in the same cell (A1) but you want to increase the value in A2 by this new number. Why do I want to do this? I have created a spreadsheet for a game and instead of using paper money I want to be able to increase or decrease the player's dollar amount by having the player (knows nothing about excel) input the dollar amount they want to either increase or decrease their running total by and I want to keep it simple for the player so they do have to add formulas when they enter the new dollar figure. Hope this makes sense? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Input dollar amount into a cell that updates another cell and more
You would need a macro or circular reference function where you would
change the iterations (I would recommend the macro) http://www.mcgimpsey.com/excel/accumulator.html -- Regards, Peo Sjoblom "Bill" wrote in message ... Help! I am racking my brain trying to figure out how to input a dollar figure into a cell (A1)that updates another cell (A2) with the running total (easy to do) but the hard part is when you want to add in the next dollar figure in the same cell (A1) but you want to increase the value in A2 by this new number. Why do I want to do this? I have created a spreadsheet for a game and instead of using paper money I want to be able to increase or decrease the player's dollar amount by having the player (knows nothing about excel) input the dollar amount they want to either increase or decrease their running total by and I want to keep it simple for the player so they do have to add formulas when they enter the new dollar figure. Hope this makes sense? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Input dollar amount into a cell that updates another cell and more
Hi,
You need a macro, right click your sheet tab, view code and paste this in Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" And IsNumeric(Target) Then Application.EnableEvents = False Range("A2").Value = Range("A2").Value + Target.Value Application.EnableEvents = True End If End Sub Mike "Bill" wrote: Help! I am racking my brain trying to figure out how to input a dollar figure into a cell (A1)that updates another cell (A2) with the running total (easy to do) but the hard part is when you want to add in the next dollar figure in the same cell (A1) but you want to increase the value in A2 by this new number. Why do I want to do this? I have created a spreadsheet for a game and instead of using paper money I want to be able to increase or decrease the player's dollar amount by having the player (knows nothing about excel) input the dollar amount they want to either increase or decrease their running total by and I want to keep it simple for the player so they do have to add formulas when they enter the new dollar figure. Hope this makes sense? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Input dollar amount into a cell that updates another cell and
Peo you are awesome!
This exacting what I want to do and now I will teach myself how to create a macro in order to make this work. Thanks again, Bill "Peo Sjoblom" wrote: You would need a macro or circular reference function where you would change the iterations (I would recommend the macro) http://www.mcgimpsey.com/excel/accumulator.html -- Regards, Peo Sjoblom "Bill" wrote in message ... Help! I am racking my brain trying to figure out how to input a dollar figure into a cell (A1)that updates another cell (A2) with the running total (easy to do) but the hard part is when you want to add in the next dollar figure in the same cell (A1) but you want to increase the value in A2 by this new number. Why do I want to do this? I have created a spreadsheet for a game and instead of using paper money I want to be able to increase or decrease the player's dollar amount by having the player (knows nothing about excel) input the dollar amount they want to either increase or decrease their running total by and I want to keep it simple for the player so they do have to add formulas when they enter the new dollar figure. Hope this makes sense? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Input dollar amount into a cell that updates another cell and
Thanks Don
Works like charm! "Don Guillett" wrote: Right click sheet tabview codecopy/paste this. Change cell address to suit. Private Sub Worksheet_Change(ByVal target As Excel.Range) With target If .Address(False, False) = "A1" Then If IsNumeric(.Value) Then Application.EnableEvents = False Range("B1").Value = Range("B1").Value + .Value Application.EnableEvents = True End If End If End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Bill" wrote in message ... Help! I am racking my brain trying to figure out how to input a dollar figure into a cell (A1)that updates another cell (A2) with the running total (easy to do) but the hard part is when you want to add in the next dollar figure in the same cell (A1) but you want to increase the value in A2 by this new number. Why do I want to do this? I have created a spreadsheet for a game and instead of using paper money I want to be able to increase or decrease the player's dollar amount by having the player (knows nothing about excel) input the dollar amount they want to either increase or decrease their running total by and I want to keep it simple for the player so they do have to add formulas when they enter the new dollar figure. Hope this makes sense? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Input dollar amount into a cell that updates another cell and more
Thanks for your help.
"Bill" wrote: Help! I am racking my brain trying to figure out how to input a dollar figure into a cell (A1)that updates another cell (A2) with the running total (easy to do) but the hard part is when you want to add in the next dollar figure in the same cell (A1) but you want to increase the value in A2 by this new number. Why do I want to do this? I have created a spreadsheet for a game and instead of using paper money I want to be able to increase or decrease the player's dollar amount by having the player (knows nothing about excel) input the dollar amount they want to either increase or decrease their running total by and I want to keep it simple for the player so they do have to add formulas when they enter the new dollar figure. Hope this makes sense? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Input dollar amount into a cell that updates another cell and
Thanks Mike for your help!
"Mike H" wrote: Hi, You need a macro, right click your sheet tab, view code and paste this in Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" And IsNumeric(Target) Then Application.EnableEvents = False Range("A2").Value = Range("A2").Value + Target.Value Application.EnableEvents = True End If End Sub Mike "Bill" wrote: Help! I am racking my brain trying to figure out how to input a dollar figure into a cell (A1)that updates another cell (A2) with the running total (easy to do) but the hard part is when you want to add in the next dollar figure in the same cell (A1) but you want to increase the value in A2 by this new number. Why do I want to do this? I have created a spreadsheet for a game and instead of using paper money I want to be able to increase or decrease the player's dollar amount by having the player (knows nothing about excel) input the dollar amount they want to either increase or decrease their running total by and I want to keep it simple for the player so they do have to add formulas when they enter the new dollar figure. Hope this makes sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use a name to represent a dollar amount | Excel Discussion (Misc queries) | |||
subsetting by dollar amount | Excel Discussion (Misc queries) | |||
sales tax total amount from one cell amount to another cell | Excel Discussion (Misc queries) | |||
make a letter in a cell automatically equal a dollar amount | Excel Discussion (Misc queries) | |||
Hide row if dollar amount is zero | Excel Discussion (Misc queries) |