Dragging in external data

A bit. I'd need to see some examples of these arrays, but I suspect you should be using a database to store this, not excel. You could then query the database to get the info you need.

As to the database, access is probably the easiest if you have it installed.

The "classic" way to do it would be a simple table in an excel sheet. Years across the top, variable names down the side, data in the middle. I used a series of arrays in VBA for ease of updating tbh, but it's still a PITA!
So an array would look like:

rates(2012) = Array("2012/2013", 8105, 100000, 0.5, 2710, 0.1, 31660, 0.2, 115630, 0.4, 0.5, 0.1, 0.1, 0.325, 0.425, 0, 0, 0, 0, 0, 0, 0)
rates(2013) = Array("2013/2014", 9440, 100000, 0.5, 2790, 0.1, 29220, 0.2, 117990, 0.4, 0.45, 0.1, 0.1, 0.325, 0.375, 0, 0, 0, 0, 0, 0, 0)

The coe then works by picking the right one in the chain.
It's pretty unreadable and a bit of a nightmare to update. SO I thought about maybe using a simple query to say a postgresql database to pick up the relevant tables. I only need to do it as the workbooks linking in could be downloaded anywhere but the central repository of variables will be held on a server somewhere.

Was wondering what the easiet way to do this would be - seeing as there are a fair number of options from what I can work out.

So I started with postrgresql then had an issue so tried out MySQL instead. SAme problem. It seems Excel needs some sort of connector - problem is that the only windows download available seems to be a 32 bit one. ANy ideas?