Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining Links when moving data | Excel Discussion (Misc queries) | |||
Copying and shifting filtered data by one row & maintaining the da | Excel Discussion (Misc queries) | |||
delete hyphens within a cell while maintaining the data therein | Excel Discussion (Misc queries) | |||
Format data in History Sheet in Excel | Excel Worksheet Functions | |||
Maintaining numerical data with <'s in pivot tables | Excel Worksheet Functions |