Maintaining history Data in Excel
 

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

Maintaining history Data in Excel
 

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'...

"Rajaraman" wrote:

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