aha! i got it now. thank you!


"Debra Dalgleish" wrote:

You could create a criteria range, with two columns with the same
heading as the date field in the data table. Use formulas to pull the
dates from the start and end date cells, e.g.:

Date Date
="=" & StartDate ="<=" &EndDate

Use this criteria range when you run the Advanced Filter.

scshop wrote:
I have a large series of data where the criteria for the data filter updates
a linked chart. The data looks as follows:

Time Stamp Data1 Data2 Data3 Data4
6/21/07 10:05AM 123 124 125 126
6/21/07 10:10AM 223 224 225 226
6/21/07 10:15AM 323 324 325 326
etc.

I use the data filter to select the criteria that is greater than or equal
to first specified date & time and is less than or equal to second specified
date & time. Because the chart is on a different sheet and there are other
input fields that are also required for the chart, Im trying to automate as
much of the charting as possible.

I have two cells where I would input the start and end dates. How do you
create a macro that will take the start date as the first criteria in the
data filter and the end date as the second criteria? The start and end dates
will vary. When Ive tried to create the macro, it will take the input start
date as the actual date, meaning, if I change the start date, I will still
get the original start date. Is there any way to use whatever I type in for
the start and end dates for the data filter criteria?

On a similar topic, since the chart updates to the parameters of the data
filter, the y-axis scale becomes skewed. Ive created a formula to calculate
the min and max for the scale. Again the macro Ive tried to create only
recognizes the actual value in the cell rather than the formula output. How
would I create a macro to recognize the result of the formula?

Thank you in advance.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html