Hi

Background:
I have data from a laser, similar to a speed gun that police use. The laser measures a sprinters velocity. I have 20 sprinters who all did a number of trials. I am currently designing a large template to quicken my data analyse I have a few last details to complete that I am having difficulty with. This is my final PhD. study! Basically I have raw data for all trials in sheet one. This raw data is then copied to another sheet. Each sheet is a specific trial. I need to analyse each trial individually, and then group the analysis onto one sheet at the end.

1) I have 28 sheets. I want to copy a graph from sheet 1 to other sheets, however I want the pasted graph to analyse the data on its respective sheet, and not sheet 1.

2) Each sheet is a trial. I need to inspect each trial individuallly.... hence one sheet per trial. However once I have inspected all sheets I want to copy all the graphs from the 28 different sheets onto one sheet.

I presume this answer involves and number of $ sign's! but am not sure

Any help in much appreciated.
Thank you
Darragh