Selecting a range of cells based on the date.

  • Thread starter Thread starter Solomon
  • Start date Start date
S

Solomon

Hi MS Office Help,

I would like to know how to choose a selection of cells based on what month
it is.

For instance, if the month was january, excel would allow me to select cells
A1-F1, which I could then use as a data source for a chart. If the month
became march or april, excel would allow me to select cells C1-H1, D1-I1
respectively, and so on. This will allow me to vary my chart automatically as
the month changes.

Help is greatly appreciated.
 
Hi Solomon,

Use the Data - Autofilter -custom feature
or Data - filter - text filters - custom
depending on your version of Excel

Hope this helps,
 
Back
Top