GlasseyeUK
Daemon Poster
- Messages
- 1,208
For my work I have to monitor a number of different performances which I record month by month on a Microsoft excel spreadsheet.
Here is my problem, because its a new team, it only started in November 2006, which ran through to March 07.
The performance monitoring restarted in April, so I need to create a new spreadsheet which my admin staff can input the data.
I need to create new work sheets for April through to October, but I don't want to have to create all the formulas, on each page.
The next problem is that on the front page of the workbook I have a summary page which automatically collates all the data month by month and totals it. Is there a way I can insert respective columns in that page, and does it automatically change the formulas respectively so it refers to the appropriate page????
PLEASE DELETE THIS THREAD JUST CHECKED BACK ON IT AND IT HAS CREATED A DOUBLE THREAD FOR SOME REASON!!
Here is my problem, because its a new team, it only started in November 2006, which ran through to March 07.
The performance monitoring restarted in April, so I need to create a new spreadsheet which my admin staff can input the data.
I need to create new work sheets for April through to October, but I don't want to have to create all the formulas, on each page.
The next problem is that on the front page of the workbook I have a summary page which automatically collates all the data month by month and totals it. Is there a way I can insert respective columns in that page, and does it automatically change the formulas respectively so it refers to the appropriate page????
PLEASE DELETE THIS THREAD JUST CHECKED BACK ON IT AND IT HAS CREATED A DOUBLE THREAD FOR SOME REASON!!
