|Subject:||Details from 52 worksheets into one master sheet Help please|
|Posted by:||Derek Peters (derek.pete…@btinternet.com)|
|Date:||Tue, 4 May 2004|
Hi Gord Dibben has given me this formula to take the details from 52 weekly
sheets and give me a total sheet for the year and it works very well (Thanks
If sheets are not named Week1 through Week2, you can insert a dummy sheet to
the right of Totals sheet. Name it Start.
Add another dummy sheet after last sheet. Name it End.
Formula in Totals =Sum(Start:End!G25)
Second method allows you to insert new sheets between Start and End sheets
your weeks progress.
Gord Dibben Excel MVP
What I would now like to do is make one sheet and have all the weekly totals
listed so I can look at it and see all the sales ,fuel and so on.
There are about 20 entries per week and I can link from a new sheet back to
Week 1 and get the data I need but do I need to do this 52 times (I E 20
links to week 1 and the same for the other 51 weeks) or can this data be
moved in a better way.
Many thanks for your help with this