Collating data....is there an easy way?

  • Thread starter Thread starter Aardvark
  • Start date Start date
A

Aardvark

Hi all,

In a single workbook I have twelve worksheets, these are values for week 1,
summaries for week 1, graphs for week 1, values for week 2, summaries for
week 2, graphs for week 2, etc up to week 4. I now want to create 3 sheets
collating the data for all four weeks. I certainly could use sum, but I
wonder if there is a better way. The cell references are the same for each
of the sheets I want to collate.

Thanks,

Danny
 
Back
Top