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

Word macro that can call cells out of Excel for a find and replace 0
Automation of scanned file storage based on content 0
Formula based on variable range 3
Reposition Cells in a Column based on another 2
Automatic filling of cells within a certain date range 1
Link a text box based on drop down box with four options MS Word 365 0
Rolling totals 1
Creating a Chart on form from selected data in query. 0

Top