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:
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.
Bookmarks