I have an Excel 2007 workbook that has over a hundred tabs (sheets). Within each sheet there is a column, L (Loading Fees). I need the loading fees from each sheet be to totaled for a specific month.
For example, in the attached spreadsheet, I show one tab. Under column L, Load Fees,
there is a list of numbers. On April 1st, I need to find the total of loading fees for the month of March, and I need to do that as the year goes on, month by month. So in May, I will need to sum the total loading fees for April, and in June sum the total fees in May, and so on.
The trick is that I need to have the loading fees summed for ALL the sheets in the workbook per month, and like I said, there are over a hundred.
To complicate things, column L on some sheets in the workbook have nothing to do with Loading Fees, so they cannot be included in the formula's action. Those tabs have 'MC' at the beginning of their tab label to designate them as different sheets not to be included in this formula's action.
I would like this function to be initiated by a button I place on a different sheet within the work book. Please see attached file and feel free to ask if any questions. Add-Monthly-Fees.xls