Hi All,
I have a workbook with several sheets containing results. I want to copy some of the data from each sheet to a summary sheet.
I will be adding more result sheets to the workbook each week. Ideally i would like to have the summary sheet update automatically, but running a macro is ok.
Becuase only some of the data is needed in the summary sheet, I thought rather than posting images I would post a link to the file.
The summary sheet just has links to the data that is needed to show any potential helpers where the data needs to come from. I hope this is Ok.
Any help would be appreciated.
Test results
I have a workbook with several sheets containing results. I want to copy some of the data from each sheet to a summary sheet.
I will be adding more result sheets to the workbook each week. Ideally i would like to have the summary sheet update automatically, but running a macro is ok.
Becuase only some of the data is needed in the summary sheet, I thought rather than posting images I would post a link to the file.
The summary sheet just has links to the data that is needed to show any potential helpers where the data needs to come from. I hope this is Ok.
Any help would be appreciated.
Test results