Excel(ent) problem!

[nil_3]

Please consider two different Excel-sheets: ---

Excel-sheet: 1
January 2005
Procured Item---Rice(Column 1)
For the Month----70 kg(Column 2)
Up to the Month---300KG(Column 3)

Excel-sheet: 2
February 2005
Procured Item---Rice(Column 1)
For the Month----45kg(Column 2)
Up to the Month---345KG(Column 3)


How can I assign a formula in the Upto the Month column of February 2005 so that the For the Month column figures of February 2005 will automatically be added to the Upto the Month column of January 2005? Or any other procedure? I just want that whenever entries are made in the For the Month column of Excel-sheet: 2, the Upto the Month column of Excel-sheet: 2 will automatically be filled by adding the For the Month column of Excel-sheet: 2 with the Upto the Month column of Excel-sheet: 1.

 

[sakumar79]

Just go to Column 3 of sheet 2, type = then select the Column2 of sheet2, type + then go to sheet1 tab and select Column3 item and press enter... ie, at C1 of sheet2, you should get '=B1+Sheet1:C1'

Arun

 

[nil_3]

It works!!! Thanks a lot.