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