Maintaining history Data in Excel

[Rajaraman]

Hi,

I wish to add values present in two cells of Sheet-1(Say for example; A1 and
B1) and produce the result in A1 of sheet-2. And, for the next time i enter
new set of values in Sheet1:A1 and Sheet1:B1, i need to have the result
displayed in A2 of sheet-2 without affecting my previous result shown in A1
of sheet-2.

Could anyone please help me in this regard???

Rajaraman.R
BI Consultant

 

[Sheeloo]

How will one know that you have entered new values?

Will you enter new values in both A1 and B1? Which cell you will fill first?

A macro can be written which when 'something' happens on Sheet1 it copies
the sum of A1+B1 to a new row in Col A of Sheet2...

You need to define that 'something'...