Adding Data then clearing the contents of the Cell

[DaveA7]

Hi, I want to be able to enter data into cell, then once I have entered the data I would like the program to automatically add the contents of that cell to a figure in another cell (A total) then the contents of the cell I entered data into be deleted. I don't mind if instead of the data being deleted, the row that the data is on is automatically hidden either.

For example:

'Enter 5 into cell'
'Press Enter button (Or click button that enables a macro)'
'5 in added to the 'total' 10'
'15 is displayed in the total cell'
'The original cell that data was entered into is now blank and the process can be repeated'

I'm thinking that this could be done using a macro and creating a button to enable that macro but i'm not sure how to do this, any help would be greatly appreciated.

Thanks

 

[ttdk1]

Suppose the original cell is at A1, the total cell is at B1, and it's sheet1, then put the following vba code in Sheet1.

Private Sub Worksheet_Change(ByVal Target As Range)

  If Not Intersect(Target, Range("A1")) Is Nothing Then
    Range("B1").Value = Range("B1").Value + Range("A1").Value
    Range("A1").Value = ""
  End If


End Sub

 

[DaveA7]

That's great thanks, sorry i'm a bit of a novice with VB code in a sheet, how do I get it to execute within the sheet?

 

[ttdk1]

in excel. use alt+ F11 to enter vba editor. under vba project on the upper left, right-click on Sheet1, select view code. Paste the code provided. Now, whenever a value gets entered into A1, the subroutine automatically does its part.