Excel info

Closed
Jiniz - Jul 19, 2015 at 08:01 PM
Hello,
I am trying to enter data in one sheet and the total should be recorded in the other sheet.

I want the total to be recorded in next cell as i erase old one & go on the other set of data entry. how do i Do it?

for example:
sheet one is for various month and i have done entry for 1st month and data gets recorded in sheet 2 as total for month one, now I want total for 2nd month but will use same sheet one. Just in sheet 2 the total to be recorded in next cell which says total 2nd month.