Using a cell for adding numbers to a different cell

[jan.henrikse]

Lets say that i want to use cell C3 to enter for an example 5 minutes, and then excel adds the amount i put into cell C3 to cell E5, and clears cell C3, and whenever i put a new number into cell C3 it takes that number and put on top of what i already have on cell E5.
If i need a button to do this its okay, but automaticly would be fine

[alansidman]

Perhaps this:

Please Login or Register  to view this content.

[jan.henrikse]

how do i add this in the worksheet?

[alansidman]

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[jan.henrikse]

seem to have done all this but cant get it to work

[jan.henrikse]

Got it working! Thanks! but is there anyway it can do it automaticly? so i dont need to go back and press al+enter in the cell ?

[alansidman]

Yes. A slight change in the code as below. Open the VBE and place this code in the worksheet event. (Double click on the sheet that you want this to work in). Paste the code in the window that opens to the right.

Please Login or Register  to view this content.

[jan.henrikse]

got it working now! think i understand more of how it works, but, how can i get these on to more rows? for anexample what put into D6 would go into C6 and D7 into C7, D8 into C8 and so on

[alansidman]

Try this and change the ranges as necessary

Please Login or Register  to view this content.