macro to change date ranges

[Darren]

I have a spreadsheet with multiple sheets. One of the sheets has historical
data that I update daily. I use this to create graphs and correlation
matrices and such. Right now I have all of my other sheets linked mostly to
the first 40 days of the historical data. What I would like to do is create a
macro that I could either enter a date range into or an amount of days into
an input cell and then have that form the input data that goes into the
graphs, matrices, etc.

For example, instead of being able to only look at the first 40 days of data
in a graph, I would like to look at the data for last June through August. Or
if that is not possible, I would like to pull data from the most recent date
to 80 days past, or 120 days past, for example. And I would like to do this
by simply changing an input cell(s).

Is this possible at all? And if so, could you give me a general idea of how
to go about it? Where can I look to find out how to do this?

Thanks,
Darren

 

[paul]

you may not need a macro but you will need to give us some idea of the type
of data you want to retreive and how it is stored?I am thinking named ranges
and the indirect function may do the trick.

 

[Darren]

The type of data I want to retrieve is just historical daily settle prices
with the most recent being yesterday's settle and going out a year into the
past. I input the data manually daily into an excel spreadsheet in the same
workbook as the sheets I want to manipulate.

Darren