Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I summarise what I want....
I have a workbook with one summary sheet and 12 month sheets. The month
sheets record business mileage and each one takes the running total from the previous month and adds the current months mileage to it. Rather than having 12 summary sheets, I would like to be able to make the one summary sheet automatically fill in the correct date of the last day of the current month and display the summary information for the current month. For example, if the current month is OCT then the OCT sheet will be the 'highest' sheet with a current mileage figure in a cell. I need the summary sheet to look for the 'highest' month sheet with a figure in the current mileage cell and automatically fill in 31-10-06 in the month ending cell as well as copy the current mileage figure. There is more I need to do, but one thing at a time. If anyone can understand my description and more to the point, knows how I can do it, I'd be grateful for any pointers. Thanks, Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
total and summarise data | Excel Worksheet Functions | |||
create sheet to summarise invoices on other worksheets | Excel Discussion (Misc queries) | |||
How to summarise data in the same place in multiple worksheets? | Excel Discussion (Misc queries) | |||
How do I summarise data from several workbooks? | Excel Discussion (Misc queries) | |||
Summarise data on multiple sheets | Excel Worksheet Functions |