View Single Post
  #1   Report Post  
philm13
 
Posts: n/a
Default Drop down defining content of a range of cells

Excel 2003
I want to allow users to choose a month via a validation box and see data
relevant to that month. Other worksheets/workbooks contain the data to be
shown - mostly in ranges of cells. I know I could do it cell by cell with
nested IF statements, but this is incredibly tedious.

Is there an easy way to do this?