Selecting a range of cells based on the 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.
 
N

Normek

Hi Solomon,

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

Hope this helps,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rolling totals 1
Combining several cells into single equasion? 1
Automatic filling of cells within a certain date range 1
Conditional Formatting based on dynamic Date 1
How do I pull data for consecutive months in an Excel spreadsheet 2
Data Validation Formula Help 2
how to know the difference value of a cell from previous value. 1
The sum of data based on words 3

Top