I have the need to always reference the last 6 sheet tabs for averages. I am looking for a way that the new tab will look at tabs 2 through 7 without having to retype the reference. Example would be first sheets 1-6 then 2-7 then 3-8 and so forth after adding new sheets 7 and 8. Attached is a file as an example. Any help or suggestions would be appreciated. Thanks
have you tried looking into 3D formula
pretty sure it works for excel 2003
Formula:
Please Login or Register to view this content.
^ this is average of month 1-6 cell A2
http://office.microsoft.com/en-au/ex...005199355.aspx
right down the bottom
If the data to consolidate is in the same cells on different worksheets
which sounds like exactly what your after
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I do believe that will do it. I will give it a try, as all averages, sums etc. are all in the same cells on the separate sheets. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks