Re: $$Excel-Macros$$ automatic update totals in cumulative colums

2012-09-06 Thread excel lerner
Hai Noorin Sir Thanks for your quick response. Small correction.Just read file1.xls is april and file2.xls is may up to march. In the month of april monthly and cumulative figures in male,female total is same. But in the month of may i enter the monthly figures in male female . *IN THE SAME MONTH

Re: $$Excel-Macros$$ automatic update totals in cumulative colums

2012-09-06 Thread NOORAIN ANSARI
Dear Excel Learner, Please try it for cumulative sum =SUM($E$4:E4,$F$4:F4) in cell G4 File 1 On Thu, Sep 6, 2012 at 2:58 PM, excel lerner wrote: > Hello sir > > In my attached files file1.xls is one month reports. file2.xls is next > month reports. > > I want to cumulative values in cumul

$$Excel-Macros$$ automatic update totals in cumulative colums

2012-09-06 Thread excel lerner
Hello sir In my attached files file1.xls is one month reports. file2.xls is next month reports. I want to cumulative values in cumulative columns automatically when i enterd present month values in monthly columns. Please help me. Thanks in advance -- Join official facebook page of this foru