Hi All
Is there a way a formulae can be produced to look at what tab number within a work book and use this as a week number?
Example,
I have 52 tabs to indicate every week of the year, I have a monthly break down and would like to group these tab numbers, into the months. E.g. Tabs 1-4 would be January.
EXAMPLE OF WHAT I HAVE GOT NOW: which is very inefficent.
Jan Feb Mar
=SUM('5:1'!M12) =SUM('9:6'!M12) =SUM('13:10'!M12)
Any one know a way this can be done???
Is there a way a formulae can be produced to look at what tab number within a work book and use this as a week number?
Example,
I have 52 tabs to indicate every week of the year, I have a monthly break down and would like to group these tab numbers, into the months. E.g. Tabs 1-4 would be January.
EXAMPLE OF WHAT I HAVE GOT NOW: which is very inefficent.
Jan Feb Mar
=SUM('5:1'!M12) =SUM('9:6'!M12) =SUM('13:10'!M12)
Any one know a way this can be done???