I regulary download a spreadsheet which has a filename format of
Data_Date_Time.xls

For example SurveyData_290905_1105.xls

Each downloaded file has identical column structure but a variable number of
rows.

I have another spreadsheet analysis.xls that does all the calculations.

I'm trying to work out the best way of being able to download the latest
data file and then for the analysis to be done on that file - without having
to set up all the links from scratch.

Suggestions will be welcome (although writing VBA is well beyond my current
position on my learning curve).

TIA

Rob

Take a look at the INDIRECT function, it should give you what you
want.
S

"RFJ" wrote in message
...
| I regulary download a spreadsheet which has a filename format of
| Data_Date_Time.xls
|
| For example SurveyData_290905_1105.xls
|
| Each downloaded file has identical column structure but a variable
number of
| rows.
|
| I have another spreadsheet analysis.xls that does all the
calculations.
|
| I'm trying to work out the best way of being able to download the
latest
| data file and then for the analysis to be done on that file -
without having
| to set up all the links from scratch.
|
| Suggestions will be welcome (although writing VBA is well beyond my
current
| position on my learning curve).
|
| TIA
|
| Rob
|
|
|