Selecting a range of cells based on the date.
in [Functions]
|
From: Solomon on 11 Feb 2010 23:59 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.
From: Normek on 12 Feb 2010 04:11 Hi Solomon, Use the Data - Autofilter -custom feature or Data - filter - text filters - custom depending on your version of Excel Hope this helps, -- Normek "Solomon" wrote: > 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.
|
Pages: 1 Prev: How do I color one cell and have another cell get same color Next: Automatic updating |