jcihar
11-27-2008, 02:33 AM
Hi,
I got stuck with a very simple and straightforward question I was asked:
The goal is to find a way how to create a master worksheet formula in workbook A (wsheet 1) and then to copy it to many others worksheets and workbooks.
If a need in future to edit/change the formulas, then the goal is only to edit the master formula - the other instances should change automatically.
I adviced to create a UDF and to save it either in PERSONAL.XLS or in .XLA file. Then I played with named formulas, which seems to me could be a solution for one workbook.
Do you have an experience with building such type of master formula and its instances through other workbooks?
Tnahk you for suggestions.
Jiri Cihar
I got stuck with a very simple and straightforward question I was asked:
The goal is to find a way how to create a master worksheet formula in workbook A (wsheet 1) and then to copy it to many others worksheets and workbooks.
If a need in future to edit/change the formulas, then the goal is only to edit the master formula - the other instances should change automatically.
I adviced to create a UDF and to save it either in PERSONAL.XLS or in .XLA file. Then I played with named formulas, which seems to me could be a solution for one workbook.
Do you have an experience with building such type of master formula and its instances through other workbooks?
Tnahk you for suggestions.
Jiri Cihar