Click here to reset your password. You MUST have a valid e-mail address so that you may receive the instructions to complete the reset.

If this is your first visit, be sure to check out the Board FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.

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......

There is a great work around
Create a Tab Start1 (this can be blank)
Create a Tab Stop1 (Also Blank)
On your Tab Period1 enter in B3 the formula:

=SUM(Start1:Stop1!B3)

Copy this to all the cells that you want summing on your template. Then drag and drop the Tabs for Period 1 between the Start and Stop.

WORD of WARNING...Do not put PERIOD1 between Start1 & Stop1 you will create serious Circular References!!!

Just repeat above with Start2, 3...until you have them all

Ps This is great if you have Departmental budgets with say 20 Depts. in one division then your boss decides that Dept 666 is now going to Move from Sales to Marketing...The Change takes 2 seconds just drag the tab 666 between the new dummy place holders and away you go.

On 2002-05-01 02:25, Ampleford wrote:
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'm unsure of where you'd like the results to be.
Would they be on a summary sheet at the front/back of the book?
Are all of the 'Periods' going to be on the Front/Back sheet?

Or, is the result of the first 4 going to be on Sheet1 of the 1,2,3 & 4, then sheet5 hold the sum of 5,6,7 & 8?