Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Use of variable to identify range of sheets in a workbook
My workbook is set up with sheets for each month. I would like to summarize
different periods in a sheet at the end (YTD). I would like to set up two cells on the YTD sheet to receive my input for the start and end sheets (Jan05 and May05 for example). I would then set up the cells on the YTD sheet to calculate summaries for the ranges input--e.g., =sum(start date:end date). Can this be done? Is my question making sense? Thanks |
#2
|
|||
|
|||
This would be a lot easier if all the data were on one sheet. You could add
a column for month, then autofilter to reduce it to any particular month at will. Read "Data across multiple sheets" at http://www.smokeylake.com/excel/excel_truths.htm. -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "rhs414" wrote in message ... My workbook is set up with sheets for each month. I would like to summarize different periods in a sheet at the end (YTD). I would like to set up two cells on the YTD sheet to receive my input for the start and end sheets (Jan05 and May05 for example). I would then set up the cells on the YTD sheet to calculate summaries for the ranges input--e.g., =sum(start date:end date). Can this be done? Is my question making sense? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
How can I assign a range starting cell based on a variable locati. | Excel Worksheet Functions | |||
How to identify source or location of MAX_VALUE in range | Excel Worksheet Functions | |||
empty variable range | Excel Discussion (Misc queries) | |||
variable range countif | Excel Worksheet Functions |