Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create formula referencing drop down list (data validation) | Excel Discussion (Misc queries) | |||
Referencing a cell dynamically | Excel Worksheet Functions | |||
copy formula referencing sheet name to another sheet | Excel Worksheet Functions | |||
Referencing labels dynamically. | Excel Programming | |||
Dynamically create Total using VBA formula | Excel Programming |