P
Piyush
Hi all,
I am working on a model for calculating Basel II related ratings which
involves creating a different spreadsheet for some 40 odd 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.
I am working on a model for calculating Basel II related ratings which
involves creating a different spreadsheet for some 40 odd 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.