Dynamically create a formula in Sheet B referencing SheetA
I am writing a scheduling program. What I want to do, through VBA, is to
create a formula in Sheet B that references a cell in Sheet A. In essence I
want to put a formula:
=MASTER!B15
in a cell in Sheet B through VBA so that if the value in Sheet A changes,
the value in Sheet B will also change. I cannot simply create the formula in
Sheet B because Sheet A changes dynamically.
Thanks in advance for any help.
--
M. Shipp
|