Microsoft excel problem....
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????
AMD Athlon 64, 2200 (11x200) 3700+,ASRock 939S56-M, SiS 756 AMD Hammer,NVIDIA GeForce 6600LE, 2048(DDR SDRAM), Maxtor 5A300J0 300GB 5400RPM, Ultra ATA/133)
Time tells all, but if the moment in time passes and you miss it, then you will remember it for ever!!