Summarise multiple sheets
 

I have a sheet for each day of the month, each sheet has 4 data columns. What
i need is a way to summarise (or auto summarise) all this data into one
seperate file.

Summarise multiple sheets
 

Hi

Create 2 new sheets and call them First and Last.
Drag these sheets so that they encompass your daily sheets.
Place your Summary sheet outside of this "sandwich"
On Summary sheet enter in cell A2 of that sheet
=SUM(First:Last!A2)
Copy across through B2:D2, then copy A2:D2 down as far as you wish
--
Regards
Roger Govier

"micksa" wrote in message
...
I have a sheet for each day of the month, each sheet has 4 data columns.
What
i need is a way to summarise (or auto summarise) all this data into one
seperate file.