Microsoft Excel 2003 (full product)

I am trying to find a way to enter multiple numbers into a single cell and just show the total. example:

Day#1- A1 enter 5 and save the spread sheet

Day#2-A1 enter 12 and save the Spread sheet.I am tracking various times on equipment, currentley I show the time for each day by saving the file per day. The total for the day is totaled in a seperate column, the issue is every day I have to physicaly do the math when entering into the same cell. Can this be done in an easier way?

You can't enter an number and a formula in the same cell, so it can't be done within Excel itself. You would need VBA...maybe something like this...

Whatever number you enter in A1 will be added to B1

Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Range("B1") = Range("B1") + Target End If End Sub

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History