You worked on this before but I need an update to the function. It is related to question http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27563074.html
, which has a few related questions that make up the total solution.
You have the Mastercard excel 2007 workbook, containing over 100 sheets.
On sheet Main, when I click the button "Create Monthly Totals", here's what it needs to do:
1. From sheet MC Consolidated, sum the values in Col E where the date in col J = the month before, and insert that summed value into B17 of BlankMonthlyTotals.xls
2. Go through the rest of the sheets to sum the total and insert that value into of BlankMonthlyTotals.xls col C17 as follows:
For all sheets (except Main, Final Report, MC Heritage Balance, MC Goga Tora, MC Reseller Offshore, MC OffShoreCommission, MC Reseller-GMT, MC HMF Cardholders and MC Consolidated) where the date in Col K = the month before, sum Col L and insert that value into of BlankMonthlyTotals.xls col C17
3. Then as it already does, save BlankMonthlyTotals.xls as LastMonth-Year.xls
Let me know if there's anything else you need or if I need to clarify.