View Single Post
  #1   Report Post  
rhs414
 
Posts: n/a
Default 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