Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to do a tally mark total?
I would like to have Excel setup so I can enter a number into F3 that would
be added to a total in B3...then have the number that was enetered in F3 deleted, thus leaving F3 blank and ready for a new entry. Is this possible and how do I set it up? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to do a tally mark total?
Hi
Have a look he http://www.mcgimpsey.com/excel/accumulator.html but make sure you read about his reservations - that there is no history of what has been entered. Hope this helps. Andy. "kurg99" wrote in message ... I would like to have Excel setup so I can enter a number into F3 that would be added to a total in B3...then have the number that was enetered in F3 deleted, thus leaving F3 blank and ready for a new entry. Is this possible and how do I set it up? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to do a tally mark total?
Right click on the Sheet Tab and select View Code. Paste in this code in the
resulting module. Private Sub Worksheet_Change(ByVal Target As Range) if Target.Address = "$F$3" then if not isempty(Target) then range("B3").Value = Range("B3").Value + Range("F3").Value Range("F3").Clearcontents end if End if End Sub -- Regards, Tom Ogilvy "kurg99" wrote: I would like to have Excel setup so I can enter a number into F3 that would be added to a total in B3...then have the number that was enetered in F3 deleted, thus leaving F3 blank and ready for a new entry. Is this possible and how do I set it up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Can excel total up the same cell reference across several workshee | Excel Worksheet Functions | |||
total a range of cells in Excel into a different worksheet | Excel Worksheet Functions | |||
show in a excel graphic a total percentage for 5 diff data fiels | Charts and Charting in Excel |