| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to summarise information from 4 work sheets | Excel Worksheet Functions | |||
| How do I summarise what I want.... | Excel Worksheet Functions | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to summarise data in the same place in multiple worksheets? | Excel Discussion (Misc queries) | |||
| Summarise data on multiple sheets | Excel Worksheet Functions | |||
Linear Mode
