Ampleford
Active Member
- Joined
- Mar 26, 2002
- Messages
- 380
I would like to refer to a series of tabs in a workbook by grouping them into periods - eg Tabs 1,2,3,4 would be week numbers so Period 1 would relate to the sum of those. Rather than create 13 periodic worksheets, can I refer to a tab (or series of tabs) by using formulae / references on 1 worksheet. eg entering "1" in the Period reference box would sum these tabs, where entering "2" would sum tabs 5-8 etc. I find it impossible to work out the syntax. To refer to cells, or to refer to areas is easy, but to refer to tabs seems beyond me.
I know I'm not explaing this very well but I've been working on this for ages and my brain is fried......
I know I'm not explaing this very well but I've been working on this for ages and my brain is fried......