Hi everyone,
I've a monthly sale data in a workbook. The figures in Sale column is YTD(cumulative). Therefore I have to deduct previous month YTD sale in current YTD figures to get the current month sale. Is there any formula so that I can get it easily.
When I use (=C6-Jan!D6) in the d6 column in MAR sheet It still takes the reference of Jan sheet But I want to take reference of FEB sheet.
Sample file is enclosed herewith.
Thanks.
Bookmarks