Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically create a formula in Sheet B referencing SheetA
try
sheets("destination").range("b1").value=sheets("so urce").range("b1") -- Don Guillett SalesAid Software "SHIPP" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically create a formula in Sheet B referencing SheetA
Those are fixed positions. I need dynamic so that the b1 changes. Some type
of loop I assume. Thanks but it doesn't fit the bill. "Don Guillett" wrote: try sheets("destination").range("b1").value=sheets("so urce").range("b1") -- Don Guillett SalesAid Software "SHIPP" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically create a formula in Sheet B referencing SheetA
For i = 1 To 10 Worksheets("Sheet B").Cells(i,"B").Formula = "=MASTER!B" & i Next i -- HTH RP (remove nothere from the email address if mailing direct) "SHIPP" wrote in message ... Those are fixed positions. I need dynamic so that the b1 changes. Some type of loop I assume. Thanks but it doesn't fit the bill. "Don Guillett" wrote: try sheets("destination").range("b1").value=sheets("so urce").range("b1") -- Don Guillett SalesAid Software "SHIPP" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |