Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I check several sheets for data in a particular cell?
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 | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
check cell val, increment val | Excel Worksheet Functions | |||
Number of worksheet tabs as cell value? ie 4 work sheets = 4 cell value | Excel Discussion (Misc queries) | |||
IF statement to check cell contents | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |