Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple worksheets, Centralized Formula Repository
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Huge Repository!!! | Excel Discussion (Misc queries) | |||
formula with multiple worksheets | Excel Worksheet Functions | |||
Formula with multiple worksheets | New Users to Excel | |||
Formula help for multiple worksheets | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |