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?
|