i have an excel 2 sheets is there - sheet1, sheet2.
in sheet2 based on process month we have to get dat previous month data from sheet1.
Exp- for process month ->Opening stock 01.09.2021 – we have get data previous month data like -->B4. if month change 01.10.2021–> we have to increase column name also like–>C4
how to get it dynamically if month change >>
can any one help ??
MonthFormulasCalulation.xlsx (9.5 KB)