I need your help!

[adamme3]

i am trying to get Excel to remember data.

I have a sheet in my excel file where company data is entered.

i need excel to save this data to another sheet for comparison so that when another set of data is entered, this is saved next to the old data on the other sheet.

so if 3 sets of data are inputted, on the comparison page, there will be 3 sets of saved data.

i have been instructed by my lecturer that this is possible through VB

can anyone help?

[albertw]

i am trying to get Excel to remember data.

I have a sheet in my excel file where company data is entered.

i need excel to save this data to another sheet for comparison so that when another set of data is entered, this is saved next to the old data on the other sheet.

so if 3 sets of data are inputted, on the comparison page, there will be 3 sets of saved data.

i have been instructed by my lecturer that this is possible through VB

can anyone help?

hi

create a button on your 1st sheet and call this cmdSave
then copy and paste the following ...

assuming data on sheet(1) is in column A (1-20)
the macro is searching for an empty column on sheets(2) starting with A
and copies it, sweeping column A on sheets(1) afterwards

 
Private Sub cmdSave_Click()
i = 0
While Not Sheets(2).Range("a1").Offset(0, i) = vbNullString
i = i + 1
Wend
NewAddress = Chr(65 + i) & "1:" & Chr(65 + i) & "20"
Sheets(2).Range(NewAddress).Value = Sheets(1).Range("a1:a20").Value
Sheets(1).Range("a1:a20").CearContents
End Sub