Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Differing Amounts of Data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Differing Amounts of Data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Help with large amounts of data and formulas | Excel Worksheet Functions |