Excel formula totalling across multiple worksheets
Posted on 2013-05-28
Hello Experts, I am hoping someone can help with searching for and totalling values over multiple worksheets -
I have an Excel file with multiple worksheets, each of which records jobs undertaken for a company in a given month.
All sheets exept TOTALS are formatted in the same way:
Column A as the date in 25.06.13 format
Column B as description of job
Column C as cost
The companies worked for vary from month to month and as such the number of worksheets, and their names, varies greatly - the only constant from month to month is the TOTALS worksheet.
I already have totals for each company in a given month however would like a breakdown on the TOTALS sheet of costs delivered on each day of that month, across all companies.
Could this be achieved with a formula? Or would it have to be a macro?
Either way could someone suggest any code/formulas which may help?