Hi Guys,
I already have had help to produce a formula to reference a large amount of data and pull one month at a time:
=IF(MONTH(DATE(2008,$E$17,ROWS($A$1:$A2)))<>$E$17,"",INDEX('0091 911'!AI:AI,MATCH(DATE(2008,$E$17,ROWS($A$1:$A2)),'0091 911'!$A:$A,0)))
I now need to adapt this so it will pull weekly data on another sheet.
I have attached the workbook beause i find it hard to explain what i mean,
I basicly want another sheet that i can choose week 1 - 52 and data from seven days will be shown.
Thanks for all your help!
Bookmarks