running tally in Excel

[travelerBT]

Hi,

New to the forum, but I am looking to do the following...

I have two worksheets, one of which is where I have an entry page for users to enter date to determine server usability.

What I would like to do is to put a button on this page that says "save" or something of that nature. What this button will do is take information that is calculated by this sheet, and transfer it to the second sheet that will have a running tally of information.

So, in other words,

I would enter 3, 10 and 34 in the first spreadsheet, click "save", and on the second spreadsheet it would reflect 3, 10, and 34 respectively.

Now, if I enter another set of 3 numbers, and click "save" it will enter those 3 numbers again on the second sheet, BUT it would be on the line right below the previous entry... hence, a running tally...

I don't know if this is even possible, but any help would be much appreciated

thanks

[Conor]

Worksheets("Sheet2").Select
For Each c In Worksheets("Sheet1").Range("Where the 3 numbers are").Cells
ActiveCell.Value = Sheet1.Range("first cell").Value
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.Value = Sheet1.Range("second cell").Value
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.Value = Sheet1.Range("third cell").Value
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.Offset(1, -3).Range("A1").Select
Next c