Sum range for all worksheets starting with a specifc name
Posted on 2010-08-27
In Worksheet.Name of "Main" in cell "K1", I need a formula that will give me the sum of all ranges A11:B12 on all worksheets with a name like "Series*".
If my sheet names for "Series" remained static, I could use a formula like this:
But the problem is, these sheet names change regularly. So one day my formula may need to be:
The one thing that remains consistent is the "Series" portion of the name. I'm guess there a way that this can be done through VBA. I'm open to any suggestions. Thanks!