MrExcel.com - Your One Stop for Excel Tips & Solutions

Dialog box for filtering Excel

Posted by Dan on March 16, 2001 8:38 AM

I have a *large* data file that I need to chart by date (column 1) and time (column 2).

Currently, I'm scrolling down the chart to find the beginning and end rows, then entering those rows into the data range for each chart.

Is there a way to create a dialog box to prompt me for the day I requre, then a second box for the time range I require, with the resuling data put into a graph?

Posted by Dave Hawley on March 16, 2001 2:56 PM


Hi Dan

I could write a simple macro to display a dialog, but before I do, follow my link to my web site and then click the link "Chart Tips and Tricks" and "Dynamic Named Ranges" there are a few method and ways that may well suit your needs.


Dave
OzGrid Business Applications