Hi all,

I am working on a model for calculating Basel II related ratings which involves creating a different spreadsheet for the 40 transactions that I have to deal with.

Each of these 40 spreadsheets has similar (but not exactly same) formulae and similar (but not exactly same) structure (ie, the way the rows and columns are arranged).

I want to create a central formula repository from where each of these spreadsheets can pick up the relevant formula so that I only have to change 1 (the central repository) sheet in case there is a change in some formulae and not have to individually update all the 40 odd spreadsheets.

Can any one point me where to start looking to solve my problem?

Many thanks,
Piyush.