I have requirement that I need to SUM the data present in daily sheets present in an excel and create a monthly sheet. Eg. I need to SUM B2 Column of each sheet and update the same in the Monthly sheet,
similarly, I need to add the same cells in all the sheets and update in monthly report.
Attached is the Daily report (Multiple sheets) and after adding Monthly report should look like the below screenshot.
Appreciate your help.
DailyReport.xlsx (9.5 KB)