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????
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????