Differing Amounts of Data

[RFJ]

I'm developing a spreadsheet to do monthly analyses.

The analyses (which are quite complex) stay constant each month and are on
one spreadsheet.

The monthly data is from another spreadsheet, provided externally. The
amount of data I get (expressed in rows) increases each month because it
adds on to what was already there. Also, the monthly spreadsheet is 'clean'
insofar as it is purely data - there are no calculations, no range names,
etc..

There is only a requirement to link to the latest monthly spreadsheet.

So my question is 'is there a more effective way to go about linking an
updated clean spreadsheet of data into my existing analysis spreadsheet
other than recreating every range name and link manually'.

TIA

Rob

 

[Jan Karel Pieterse]

Hi Rfj,

So my question is 'is there a more effective way to go about linking an
updated clean spreadsheet of data into my existing analysis spreadsheet
other than recreating every range name and link manually'.

There is: Data, get external data, new database query, choose Microsoft
Excel files. If you define a couple of dynamic range names pointing to the
resulting data you should be able to simply click data, refresh data next
time.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com